Help with Talend Job: Synchronize a Salesforce Account object --> to --> MySQL table

[jlig]

I'm trying to create a new job that when run will:

1. Export "Account" object from Salesforce
   • Connection test successful
2. Import into MySQL table called "sf_Account"
   • Connection Test successful

I've created the Salesforce component fine, and added in the MySQL component as well, but when I run it, I get the error: 

[TRF]

Share your tSalesforceInput component settings

[jlig]

[TRF]

Probably something wrong in the schemas like a field name terminated by an underscrore "_".

See this link https://www.theserverside.com/tutorial/New-Java-7-Features-Numeric-Underscores-with-Literals-the-OCP...

[jlig]

Thanks for the help on this!

In case this was an issue with some of my field names I unchecked all of the fields except the top 4 but get the same error/issue? 

I also read thru the doc link you provided. 

Do you know of a good tutorial on creating a Salesforce Table in MySQL using Talend?

[jlig]

Here is my JVM version. (Using Talend 6.5.1)

[TRF]

Still the same error at runtime?

If so, click on the Code tab then go to the line where the compile error occurs and share the error message.

[jlig]

I didn't even notice that "Code Tab" there... thanks!

When I click on the red error on the right, it highlights the numbers in my password?

• Could it be having issues with my very secure password?
• Is there a way around that, as I cannot change the password to the MySQL server?

[jlig]

Ok, I got around the previous error by creating a new MySQL user & pw without any "underscores."

Now I'm getting the following error on the "IsDeleted" column? I've searched the web for a workaround.. no luck yet.

• This is a standard Salesforce column
• I'd prefer to have all of the Salesforce columns mirrored in the MySQL local table if possible..

[jlig · Accepted solution]

Here is my final working job setup:

• Basically, I had to use the tMap connector to map the fields from SF ---> MySQL and set all of the "boolean" type fields to a length of 1