Example of a CSV text file

The CSV text file contains the information about all the database connections. You can create and then import this file to add the database connections that you defined. You can also use the sample CSV text file that comes with your product. This CSV sample text file is in the samples subdirectory of the installation directory.

Parameters for the CSV text file

The following table describes the parameters that you can define in the CSV file.
Table 1. Parameters for the CSV text file
Parameter Explanation
name (required) The unique database connection name.
The name parameter is the identifier for a database connection, and so each connection must have a unique name.
Note: When you import connections from a file, if the import file contains a duplicate name, the import wizard prompts you to either update the connection properties with the new data, or to keep the existing connections without modifications.
dataServerType (required) The database server type. The following values are permitted:
  • DB2LUW
  • DB2Z
  • INFORMIX
  • INFORMIX_JDBC
Attention: Some products support a limited set of database servers. Before you import a data source connection file, make sure that the included dataServerType entries are supported by your product.
db2instance (optional) The DB2® instance name.
databaseName (required) The database name for this database connection.
host (required) The IP address or IP name of the host where the database exists. To retrieve the host name, run the TCP/IP hostname command on the server. To retrieve the host IP address, run the ping host_name command on the server.
port (required) The port number where the database is configured.
user (optional) The database user name.
password/password.decrypted (optional) The password for the database user. If you use the password parameter, the password that is specified in the definition must be in the encrypted form.
location (required for DB2Z) The location of the DB2 for z/OS® system.
databaseAlias (optional) The alias of the DB2 command line processor (CLP). This parameter can be used for data server types DB2LUW and DB2Z only.
INFORMIXSERVERNAME (required for INFORMIX_JDBC, optional for INFORMIX) The name of the Informix® database server.
xtraProps (optional) Additional properties such as connection properties as defined in the JDBC driver documentation for the database server type.

Example: traceLevel=32

URL (see the explanation) The JDBC URL of the database server. The URL parameter is required if the data server type is not supported by default.

If you do not enter a value for this parameter, a default URL is created for the connection.

comment (optional) A descriptive comment for the database connection.

You can see a sample of CSV text file in the samples subdirectory of the installation directory.


Feedback