topic Re: Help with Talend Job: Synchronize a Salesforce Account object --> to --> MySQL table in Talend Studio

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

jlig — Sat, 16 Nov 2024 08:13:40 GMT

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

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 — Wed, 23 May 2018 23:52:21 GMT

Share your tSalesforceInput component settings

jlig — Thu, 24 May 2018 14:54:04 GMT

TRF — Thu, 24 May 2018 15:03:47 GMT

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

jlig — Thu, 24 May 2018 20:28:15 GMT

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 — Thu, 24 May 2018 21:55:23 GMT

Here is my JVM version. (Using Talend 6.5.1)

TRF — Fri, 25 May 2018 08:25:09 GMT

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 — Fri, 25 May 2018 14:54:23 GMT

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 — Fri, 25 May 2018 15:42:03 GMT

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 — Tue, 29 May 2018 15:36:42 GMT

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