slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SSIS/DTS | New Thread

View: Search:

Author

Thread: data import and export

Chokri
Posts: 62

data import and export Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Sep 07 5:47 AM

we are currently using Scribe software to link (via an ODBC driver and a Saleslogix Adapter in Scribe) to link to an Oracle database and import data from the Oracle database into a Saleslogix database. This configuration seems fairly straight forward however we have had situations where some of the data is not getting updated in Saleslogix. I am looking at an alternative way of importing and exporting data to and from an Oracle database. Any suggestions would be appreciated.

[Reply][Quote]

Snow Monkey
Posts: 214

Re: data import and export Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Sep 07 1:15 PM

What specific data and fields columns(in slx) are we talking about here?

[Reply][Quote]

Chokri
Posts: 62

Re: data import and export Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 07 3:00 AM

Updating the contact, address and company tables. Fields concerned are contact name, company name, all the address fields, and company name (if one does not exist it creates a new record).

[Reply][Quote]

Snow Monkey
Posts: 214

Re: data import and export Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 07 10:34 AM

How does that oracle system know which entity to update in slx? by contact and account names? normally names can be very confusing. abc company inc and com incormporated is different.You have to use a tool like paribus to dedupe this if thatis the case.

Another option is to write the ID to that ora system whenever a new slx contact/account is created ? can you do that? do you have remotes in your slx setup?answer can change depending on that.

and finally when you say sometimes it is not cmoing thru thru scribe, did you check the logs etc in scribe server(i dont have the server component installed and i do my processing a lil different way)

Tell us which direction you can proceed.Some shops(or some bosses) dont like some integration techniques;we have a lotta ppl who are hell bent upon writing things to a textpad before taking it to another system and any file transfer has to be a secured ftp

)

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 4:38:40 AM