Hello,
I'm trying to extract from my company's Salesforce database, and copy the data into an AWS MySQL database.
I am able to connect and pull the schema from the Talend application, and I set a job up with the Account object in my Salesforce Org. From what I can tell, all of the credentials are input correctly.
My AWS security group has an allowed policy for my IP address, but i still get the following errors on the job :
****************
connecting to socket on port 3700
connected
Exception in component tMysqlOutput_1
java.sql.SQLException: Access denied for user '(Username)'@'c-(IPAddress).hsd1.pa.comcast.net' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2312)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
disconnected
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at sqmigration.sfdcmigration_0_1.SFDCMigration.tSalesforceInput_1Process(SFDCMigration.java:2391)
at sqmigration.sfdcmigration_0_1.SFDCMigration.runJobInTOS(SFDCMigration.java:4799)
at sqmigration.sfdcmigration_0_1.SFDCMigration.main(SFDCMigration.java:4667)
Job SFDCMigration ended at 16:17 16/09/2012.
************
Any idea of what this could mean? Is there something else in Talend I might need to configure to copy the data into the database tables?
Any help is appreciated. If you need more details, I'm happy to provide, I'm just not sure what could help.
Thanks,
C
