Using Native Database Interfaces

Table of Contents

About native database interfaces
What is a native database interface?
Components of a database interface connection
Using a native database interface
Supported versions for Informix
Supported Informix datatypes
Basic software components for Informix
Preparing to use the Informix database
Defining the Informix database interface
What to do next
Microsoft SQL Server
Supported versions for SQL Server
Supported SQL Server datatypes
Basic software components for Microsoft SQL Server
Preparing to use the SQL Server database
Defining the SQL Server database interface
Migrating from the MSS or OLE DB database interfaces
SQL Server 2008 features
Notes on using the SNC interface
Supported versions for Oracle
Supported Oracle datatypes
Basic software components for Oracle
Preparing to use the Oracle database
Defining the Oracle database interface
Using Oracle stored procedures as a data source
Using Oracle user-defined types
What to do next
Adaptive Server Enterprise
Supported versions for Adaptive Server
Supported Adaptive Server datatypes
Basic software components for Adaptive Server
Preparing to use the Adaptive Server database
Defining the Adaptive Server database interface
Using Open Client security services
Using Open Client directory services
Using PRINT statements in Adaptive Server stored procedures
Creating a DataWindow based on a heterogeneous cross-database join
What to do next
Installing InfoMaker stored procedures in Adaptive Server databases
What are the InfoMaker stored procedure scripts?
How to run the scripts
Using the DirectConnect interface
Basic software components for the DirectConnect interface
Supported versions for the DirectConnect interface
Supported DirectConnect interface datatypes
Preparing to use the database with DirectConnect
Defining the DirectConnect interface
Creating the extended attribute system tables in DB2 databases
Creating the extended attribute system tables
Using the DB2SYSPB.SQL script

About this chapter

This chapter describes the native database interfaces. For each supported interface, it then explains how to prepare to use the database and define any unique database interface parameters so that you can access your data.

For more information

This chapter gives general information about using each native database interface. For more detailed information:

  • Check to see if there is a technical document that describes how to connect to your database. Any updated information about connectivity issues is available from the the Appeon Support Web site at

  • Ask your network or system administrator for assistance when installing and setting up the database server and client software at your site.