UCCX 8.5 Informix/SQL Server linked server question

Answered Question
May 21st, 2012
User Badges:

We have several custom (in-house) queries that were written against a UCCX 7.x installation (SQL Server). These queries were written using a variety of t-sql functions (DATEADD, DATEPART, GETDATE etc). When we migrate to UCCX8.5 (Informix) I'm assuming we will need to translate those t-sql functions to their equivalent Informix functions...is that a correct understanding?  Has anyone else faced a similar situation?  Any gotchas to share?


Also would be interested to hear from anyone who defined a linked server in SQL Server to the new Informix database server....how did it go, any gotchas there?


Thanks!!!

Correct Answer by Gergely Szabo about 5 years 1 month ago

Hi,


... or, you can just copy data from Informix tables into a MS SQL server and use the familiar T-SQL syntax. This approach is recommended by Cisco AFAIK.


G.

Correct Answer by Aaron Harrison about 5 years 1 month ago

Hi


That's pretty much it - there are equivalent functions for most things, and the syntax (beyond the basic selects) is quiet different and there are some random restrictions on the structure of queries that I don't think applied in MS SQL. A good way to learn is:


- Comparing the MSSQL and Informix equivalents of the standard UCCX procedures

- The IBM 'boulder' website tends to show up on most searches on google for informix commands and has lots of info on syntax etc.


I find Informix more difficult than SQL as it's less forgiving and you don't get decent tools to debug/verify syntax etc without paying out some money..


I've never had a need to do a linked server.


Regards


Aaron

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Correct Answer
Aaron Harrison Mon, 05/21/2012 - 22:43
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


That's pretty much it - there are equivalent functions for most things, and the syntax (beyond the basic selects) is quiet different and there are some random restrictions on the structure of queries that I don't think applied in MS SQL. A good way to learn is:


- Comparing the MSSQL and Informix equivalents of the standard UCCX procedures

- The IBM 'boulder' website tends to show up on most searches on google for informix commands and has lots of info on syntax etc.


I find Informix more difficult than SQL as it's less forgiving and you don't get decent tools to debug/verify syntax etc without paying out some money..


I've never had a need to do a linked server.


Regards


Aaron

Correct Answer
Gergely Szabo Tue, 05/22/2012 - 01:40
User Badges:
  • Green, 3000 points or more
  • Community Spotlight Award,

    Member's Choice, December 2015

Hi,


... or, you can just copy data from Informix tables into a MS SQL server and use the familiar T-SQL syntax. This approach is recommended by Cisco AFAIK.


G.

dbguy1611 Tue, 05/22/2012 - 06:32
User Badges:

Thanks for your reply/suggestion. A quick follow-up question...I'm assuming it's up to us to provide the data export/import processes to populate a SQL Server DW from the Informix dbserver (i.e. there isn't a pre-built process provided by Cisco is there)? I would probably use SSIS but don't want to re-invent the wheel if it's already available :-)


Thanks again!

Chris.

Gergely Szabo Tue, 05/22/2012 - 08:02
User Badges:
  • Green, 3000 points or more
  • Community Spotlight Award,

    Member's Choice, December 2015

Hi,

no, there's no built-in process for pushing data out of UCCX I am aware of. SSIS would be fine.

Creating an ODBC datasource to Informix is easy (found a couple of examples and step-by-step guides using Google), and once you got that ODBC datasource registered and functional, you can do (almost) anything. Like, for instance, a scheduled job.

To be quite honest with you, I never tried that (I do UCCE reporting, but not UCCX), but right now I am downloading the Informix Client SDK from the IBM developer website just to give it a try with our lab UCCX server. db_cra, here I come!

G.

Actions

This Discussion