![]() ![]() Test the connection with the mqsicvp tool: Mqsisetdbparms -work-dir /root/demo/ace1 -n odbc::DEMODB -u postgres -p Passw0rd Here we assume that the password for the postgres user is Passw0rd and that we are running on an independent integration server whose working directory is /root/demo/ace1 The directory must be created in advance using the IntegrationServer or mqsicreateworkdir commands: ![]() InstallDir=/root/ace-12.0.8.0/server/ODBC/driversĬreate an ODBCINI environment variable that points to the odbc.ini file and an ODBCSYSINI environment variable that points to the directory with odbcinst.ini:Ĭreate a security identity for the user accessing PostgreSQL. The database name and username are postgres:ĭriver=/root/ace-12.0.8.0/server/ODBC/drivers/lib/psqlodbc.so In our example below, the name of the ODBC data source is DEMODB and it points to a PostgreSQL server running on localhost. Set the group ownership of these two files to mqbrkrs:Ĭhange the ini files. Make a copy of these two files to a directory of your choice (in our case /root/demo/):Ĭp /root/ace-12.0.8.0/server/ODBC/unixodbc/odbc.ini /root/demo/odbc.iniĬp /root/ace-12.0.8.0/server/ODBC/unixodbc/odbcinst.ini /root/demo/odbcinst.ini You will find the following ODBC driver files:Ĭopy the driver to the App Connect Enterprise ODBC drivers directory:Ĭp /usr/pgsql-15/lib/psqlodbc.so /root/ace-12.0.8.0/server/ODBC/drivers/lib/.Īpp Connect Enterprise provides templates for the odbc.ini and odbcinst.ini files. Verify that a group named mqbrkrs is created:Ĭat /etc/group | grep mqbrkrs Set up an ODBC data sourceĪfter installation, the PostgreSQL libraries are available in the directory (here we assume version 15): root/ace-12.0.8.0/ace make registry global accept license In this case, the files were extracted in the root user's home directory: Check the App Connect documentation for more installation instructions.ĭownload (from Passport Advantage or Fix Central) and extract the installation package: For example:įor simplicity, in this demo we will install ACE and run it as root on the same Linux machine. The following commands can be used to list databases and check connection information:Ĭreate a simple table for testing. Set the password for the postgres user (automatically created during installation):Ī prompt similar to the following appears, indicating that you are connected to the default database, also known as postgres: Install additional libraries required for ODBC: usr/pgsql-15/bin/postgresql-15-setup initdb Install Postgres server (version 15 in this case): The following commands were used in the described example:ĭisable the default module that comes with Linux (usually not the latest version): Click Download, select your Linux distribution, and provide version and platform details to generate the installation commands. All commands are executed with root or postgres user identity. Similar steps can be performed on other Linux distributions. ![]() The example described in this blog was tested on CentOS 8. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |