How does connect it work (is it what I need)

[daurkin]

Hello group,
We are getting ready to make a jump to SC 6.2 and at the same evaluate some of our manual processes to see if they can be automated. Last year we introduced the SCAuto for handling home grown self-service tickets. Now I'm looking for a way to manage the contacts, companies, and location tables in ServiceCenter so they pull data from a master database. The master database is on a SQL database and I have have just read-only access to it.

I'm reviewing the option of Connect-It being we've owned it for many years and never did anything with it. Can connect it monitor a SQL database on the network for updates and replicate the change to our tables and fields? I have the instructions but still not sure of the grand scheme of how it works. Am I on the right path and is it relatively easy.

[tommy]

Yes ConnectIt would be the right tool to use to import data from your databases.

It is pretty straight forward. On SC you need to setup the relevant input events and then it is pretty much just a drag&drop job to setup the scenario.

[Raoul.vanderbeken]

Connect-IT could be a solution for your problem. I consider it as a mapping tool which allows you to connect to any standard source to any Peregrine product.(depending on your license)

You select your source and desctination and between them you apply a logic (mapping).

[MinervaRJP]

Connect-It is used for exactly this type of thing all over the place. What did you choose? How did it work out for you?