Replicating data between I-series and Ms-CRM using Scribe?

0 pts.
Tags:
AS/400
CLP
CRM
DataCenter
DB2 Universal Database
PC/Windows Connectivity
SQL
SQL Server
We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used scribe before with I-series? If so, how did you find it and what were the problems? Thanks.
ASKED: February 28, 2006  12:36 PM
UPDATED: March 2, 2006  8:54 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

We’re in the process of doing the same thing right now. I’ve setup an ODBC connection (using iSeries Access) on the server that Scribe is running on, and delivered a prototype SQL statement to our contractors for the tables that they need to access. I used the SQL script environment in iSeries Access to generate, test and save that script. They will need to translate the SQL to scribe and make sure they use the ODBC data provider. So far so good…

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DaveMi
    I would take a look at Transformation Server from Data Mirror. It can replicate data between the iSeries and SQL server.
    0 pointsBadges:
    report
  • Fastfred1
    I would suggest moving the data with a sql server dts (data transformation services) package.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following