Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Friday, November 22, 2024
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
11/22/2024 3:55:08 AM
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:
Dynamic
Flat
Tree
Search:
Author
Thread: data import and export
Chokri
Posts: 62
data import and export
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
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
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
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:07:48 AM