About preconfigured database types

The IO Design perspective supports the following preconfigured database types:

DB2

Informix

MySQL Enterprise

Oracle

PostgreSQL

SQL Server

Sybase

The connection type configuration and mappings files for preconfigured database types are located in the following iHub and BIRT Designer Professional directories:

$AC_SERVER_HOME/etc

<BDPro_HOME>\eclipse\plugins\com.actuate.ais.embeddable_<version>
\Config\aisconfigfiles\etc

The connection type configuration for preconfigured database types resides in the file intsrvrsources.xml. Do not modify this file.

The mapping for a preconfigured database type resides in the mappings.xml file in the directory for that type. For example, Figure 7‑4 shows the location of the mappings.xml file for the SQL Server database type.

Figure 7‑4 Location of the connection type configuration file and mappings files for preconfigured database types

The following topics explain how data types for preconfigured database types are mapped to Actuate SQL data types and vice versa. Some database data types cannot be mapped to an Actuate SQL data type, for example binary types with specially defined operations. These topics also discuss special considerations for each database type.