Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sql Server Adapter for Oracle ICS

edited Nov 15, 2017 8:00AM in Integration 5 comments

Summary

Sql Server Adapter for Oracle ICS

Content

Hello,

I am testing a connection from Salesforce to an on-premise SQL Server database and am confused about some aspects of the SQL Server adapter. The Salesforce connection seems to work fine and on the mapping screen for the integration I see the data model. But, on the SQL server side of this same screen, I only see a single line with "input." I'm trying to figure out how to see the data elements on the mapping screen. Do I need to use XSLT?

For the SQL Adapter the connection seems to work fine. On the integration screen I choose "execute SQL Query" and enter something simple like "Select top 100 * from table_table." I see an xsd and I see all of the table's fields on that xsd, but none of them appear on the mapping page for the target. So far, I can't find any documentation on how to do this. I've tried a few variations, but I still only get the root node with "input." Lastly, there is an on-premise agent setup for use and I've assigned the connection to that

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!