Lucent CMS to SQL 7.0 2

[DerickD]

Does any one know a 'simple' but fully automated way of getting data from the CMS (Informix 7.0) to SQL server....

I am trying to create a Central SQL database for 5 CMS's that the company is using so I can can use this for reporting purposes. I have been lookin into using the OpenLink ODBC Connection that comes with the CMS so I can create a DTS in SQL for Daily Imports of the previous days data. But I get the message that the ODBC Drives are not supported for this action and always fails on the first row of all tables. I have found ODBC Driver that say they work but cost $$$$$...

....Does any one know a 'simple' but fully automated way of getting data from the CMS (Informix 7.0) to SQL server

 

[europe]

It is calles External Call History, and you must have some budget Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe

 

[DerickD]

Thanks for taking the time, we already have ECH installed for all our call center but, as you might know the data is almost raw, and hardly any compiling has been done. I have looked into using it, but as it records all calls through the Lucent the data would be harder to filter to retrive the reports that are needed......Is there any other way?

 

[DerickD]

We do have a budget, but if I can do it for $$ as aposed to $$$$ then every one will be happy!

 

[mclellan]

I'm not a report export, but could you site up a nightly report and dump it to a particular directory, then write another process that would pick this report up and load it into your new database?

Just a thought
Barry

 

[telcoguy]

You can use cmsql to create a delimited file outputs, and import those into your Microsoft SQL server.
We do the same thing (only on MySQL) daily on about 13 servers.
Completely automated and free, as cmsql is inlcuded in CMS allready.


Hope this helps,


Rob

 

[DerickD]

OK, theree are all very good solutions, but, is there any way you can config. SQL to use the CMS as a remote / Linked server?

 

[chriscarr]

Haven't found a way to link directly to CMS from SQL Server (7 or 2000), but can link via MS access. Then used DTS to transfer data to SQL server. Only problem is if all licences are in use the DTS package does not interpret the error correctly and will run until you cancel and restart it.

 

[DerickD]

Hey Chriscarr,

Thanks for the addition..I have been looking into it for some time now, and I cam up with the solution that you can import / Export using the Transfere command with the Connection string that you find for Linked CMS tables in Access. Takes some testing, but it does work..

 

[dclark10]

DerickD:
Great post! We are in need of this connection string to build a 3rd party application for importing sign in/outs on Avaya. Do you have the exact connection string you used to connect to CMS? Our programmers are having difficulties..please help.

 

[RGarcia87]

We had to purchase a driver to access the tables.

 

[dclark10]

richgarcia87:
Thanks for the reply. We also bought the Informix ODBC drivers however I was looking for a connection string we could use to add into a custom 3rd party application. It would look something like:

"Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd


It seems DerickD was able to use a connection string that worked and I was hoping to test it in our application.