Database Connection Information
A database alias consists of the following information:
The type of database and where it is located. JDBC uses a URL naming scheme to locate and identify databases. Each JDBC driver responds to a slightly different syntax for these URLs. Consult the documentation for the driver you are using for details. If you are using the JDBC-ODBC bridge driver, the URL is
jdbc:odbc:your-datasource .
The user name and password required to connect to the database. If the database requires a user name and password to connect to it, you must specify the server with the user name and password it should supply.
The JDBC driver. You identify the fully qualified Java class name of the JDBC driver to use for this connection (for example,
com.company.jdbc.Driver). This class must be in the server’s classpath.
The server uses the database connection information to connect to a database when:
You use the
Integration Server Administrator to display information about database tables when creating a database service (Generate from table). The server must connect to the database to get information about the structure of the database.
The server executes a database service that was created using the
Integration Server Administrator.