Informix data to Microsoft SQL

Version 1
    This document was generated from CDN thread

    Created by: Kleid Gjataj on 07-08-2013 11:54:14 AM
    Is there a way to access the UCCX informix data and dump it into SQL periodically?

    Thanks,
    -KG

    Subject: RE: Informix data to Microsoft SQL
    Replied by: david perlis on 09-08-2013 07:37:03 AM
    Hi KG,

    There are several ways to accomplish this, you can use Microsoft SQL's DTS packages or other tools, but they are not the easiest to work with and you have to watch out for data type cpnversion errors. We had a similar requirement for a client, so we built our own connector that allowed for the proper transformation of datatypes and used the Windows scheduler to set up when we wanted it to run.

    Let me know if you would like more info on this.

    David Perlis
    Stack8 Technologies Inc.