Infor CRM

From Starfish ETL
Revision as of 21:01, 10 December 2018 by Adsouza (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

To connect to Infor CRM, formerly SalesLogix, with the OLE DB Connector in Starfish, select the OLE DB Connector and click Build Connection... Select the SLXOLEDB Provider and fill in the other necessary information including Password, User ID, Initial Catalog, Data Source, etc.

When inserting into Infor CRM, you need to generate IDs for the ID fields. If you open the ID field's Function Field window, there should be a tab called SalesLogix ID which will generate an ID for you.

It is recommended that you set the Starfish Application Pool user to use the "Local System" account. This will give the SLXOLEDB provider the necessary permissions to perform Connection related system/registry updates.