iopdesigner.blogg.se - Download informix odbc driver

#Download informix odbc driver how to
#Download informix odbc driver install
#Download informix odbc driver 64 Bit
#Download informix odbc driver driver

Do not modify any other occurrences of within odbc.sh. Replace this placeholder with the directory path.

Provide the location of the directory where the Informix Client Software Developer's Kit (CSDK) is installed.

Edit the ODBC.sh file and make the following changes:.

Add Write privileges to the ODBC.sh file by entering the following command: chmod u+w ODBC.sh.

In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.Browse to the folder env.

#Download informix odbc driver how to

The following set of instructions are divided into two sections: how to configure the environment and how to configure a DSN. The directory where CSDK is installed should always be accessible to Intelligence Server.

#Download informix odbc driver driver

The following steps show how to configure the MicroStrategy ODBC driver for Informix 8. For information on installation, refer to the product documentation provided directly by the database vendor. This software is not included in the MicroStrategy product suite installation and must be obtained through the database vendor or a third party. However, the Informix Client Software Developer's Kit (CSDK) must be installed before you create a DSN. The ODBC Driver for Informix 8 for Linux is a MicroStrategy-branded ODBC driver, but it is not accessible through the Connectivity Wizard. There are many clients available on the web, on this guide I will use the Server Studio from AGS which is a free client and you can download it here.The MicroStrategy ODBC Driver for Informix 8 is already installed in the INSTALL_PATH /lib directory. Click on “Apply and Test Connection” and ensure the connection is successful.

Password: Password of the username (reset from the password management page)ģ.

UserID: The wallboard user or uccxhruser.

Hostname: The actual hostname or IP address of the UCCX.

The servername will be “i1_uccx116pub_uccx” Hostname: UCCX116PUB-1 = Servername will be “uccx116pub_1_uccx” Hostname: UCCX116PUB = Servername will be “uccx116pub_uccx”

Add “_uccx” to the end of the hostname.

If the hostname of the UCCX begins with a number, add “i” in fornt of it.

Any hyphens to be converted to underscore.

All upper-case letters to be converted to lower case.

There are specific rules for entering the name and they have to be followed:

Server Name: This is the name of the instance of the Informix database.

Now we will create a new “DSN” based on the information below:

#Download informix odbc driver 64 Bit

By default 64 bit Windows runs the ODBC Administrator Utility 64 bit instead of the the one that we just installed (32 bit), this causes the IBM INFORMIX ODBC DRIVER option NOT to be visible, you can find the ODBC Administrator Utility 32 bi tat ‘ C:\Windows\SysWOW64\odbcad32.exe‘.Ģ.

#Download informix odbc driver install

In order to keep things simple you can download the IBM Informix Client SDK Install 4.10 TC7right here, remember to run the installer executable with windows “admin” rights.

You can find the latest SDK directly from the IBM website but you will find an unpleasant registration process.

First we need to download the IBM Informix Client SDKthat will allow the client to establish the ODBC connection with the CCX DB.

uccxwallboard: This user has access to real-time database tables that contain snapshots of real-time statistics, specifically to tables RTCSQsSummary and RTICDStatistics.įor the purpose of this configuration we are going to use the uccxhruser.

uccxworkforce:This user has access to the Team, Resource, and Supervisor tables and it’s used for Cisco Unified Quality Management (QM).

uccxhruser: This user has access to many configuration and historical tables in the UCCX database and should only be used only for custom historical reporting and Cisco Unified Workforce Management (WFM).

UCCX provides three different users that can be used to access the database directly in order to extract information for the purposes of wallboard applications, Quality Management, Workforce Management, and custom historical reporting.