Table of Contents

Overview

Accessing the Database Configuration dialog

Connecting with the DB2 database

Installing DB2 driver

Creating a cache

Mapping the transaction object

Connecting with the Informix database

Installing Informix driver

Creating a cache

Mapping the transaction object

Connecting with the MySQL database

Installing MySQL driver

Creating a cache

Mapping the transaction object

Connecting with the Oracle database

Installing Oracle driver

Creating a cache

Connection types in Oracle

Mapping the transaction object

Connecting with the PostgreSQL database

Creating a cache

Mapping the transaction object

Connecting with the SQL Anywhere database

Starting the SQL Anywhere database

Configuring ODBC for SQL Anywhere

Creating a cache

Mapping the transaction object

Connecting to SQL Anywhere database in Linux

Connecting with the SQL Server database

Selecting a proper authentication mode when configuring SQL Server connection

Configuring the SQL Server database server

Creating a cache

Connecting to Azure SQL

Mapping the transaction object

Connecting with the Adaptive Server Enterprise database

Configuring ODBC for ASE

Creating a cache

Mapping the transaction object

Troubleshooting

Unable to connect to remote SQL Server database over Named Pipes even though local database can be connected

Using the PostgreSQL CA certificate for SSL connection, the verification fails

Communication error when connecting with the Informix database