Forum Discussion
dvnitsch21
2 years agoNew Member
Proxyaddress error when bringing in Salesforce and SQL Server data to dataflow
Hello, I am attempting to bring in data from a Salesforce object and a SQL Server instance to the same dataflow. I am able to bring in both individually but once I try connecting to both I get an err...
aj1973
2 years agoCommunity Champion
Hi dvnitsch21
before merging check out the Field id of both Tables if there is an issue with one or multiple cells. Looks like the Gateway could not parse and id in line 7.
dvnitsch21
2 years agoNew Member
I don't see any issues, I think the error is on line 7 and not row 7 of the tables. I still get the error if I don't do the merge and just attempt to refresh the SF data.
- aj19732 years agoCommunity Champion
I see,
Try to add a SQL code to the SF table to CAST the id field before calling it into the dataflow.