How to create a data connection definition for a database

1	In Navigator, select the appropriate project.

2	Choose File→New→Data Connection Definition.

3	In New Data Connection Definition:

In Name, type the name of the database.

In Type, choose a type from the drop-down list.

In Description, type a description for the database.

To retrieve the connection property values from the data source connection configuration file at run time, type the configuration key in Configuration key.

Figure 2-5 shows an example of creating a data connection definition for a SQL Server database.

Figure 2-5

Creating a data connection definition for a database

Choose Finish.

The IO Designs folder hierarchy and data connection definition file name appear in Navigator, and Data source connection properties appears. Connection property values stored in the data source connection configuration file are not displayed.

4	In Data source connection properties:

If you did not provide a configuration key earlier, you may provide one now.

In Credentials, choose Proxy or Passthrough.

If you choose Proxy, Information Object Designer connects to the database using the user name and password you specify in Data source connection properties. If you choose Passthrough, Information Object Designer connects to the database using the user name and password you specify in User Information. For information about using proxy and passthrough security in an Encyclopedia volume, see Managing an Encyclopedia Volume.

If you chose Proxy, type the user name and password for the database user.

In Port, type the number of the port that Information Object Designer uses to connect to the database server.

Provide values for the remaining properties.

The remaining properties are specific to the connection type.

Figure 2-6 shows an example of specifying the connection properties for a SQL Server database data connection definition.

Figure 2-6

Specifying data source connection properties for a database data connection definition

Choose Test Connection to test the connection to the database.

If you chose Passthrough in Credentials, type the database user name and password in User Information and choose Finish, as shown in Figure 2-7.

Figure 2-7

Providing user information to connect to the database

If Information Object Designer connects to the database, a confirmation message appears. Choose OK.

Choose one of the following:

Map tables, to create maps of database tables and views

Map stored procedures, to create a map of a stored procedure result set

Create SQL map, to create a map of a query written in the database’s native SQL

Copyright Actuate Corporation 2012