Connector Xpress Guide › Screens and Dialogs › Edit Source Dialog

Edit Source Dialog

The Edit Source dialog lets you specify the name and connection details for your data source. For JDBC data sources, this dialog lets you construct an appropriate JDBC URL for the database you select. For JNDI data sources, the dialog lets you specify the details of an LDAP connection.

Note: The fields in this dialog vary, depending on the type of data source selected.

This dialog contains the following fields:

Name

Specifies the name of the data source.

Note: We recommend that you chose a name that clearly describes what the data source is for.

Server Name

Specifies the host name of the server you want to access.

Host Name

(Informix Dynamic Server) Specifies the name of the Informix server.

Database Type

(JDBC only) Specifies the type of database connection you want to make:

• DB2
• DB2 for IBMi
• Informix Dynamic Server
• INGRES
• Microsoft SQL Server
• MySQL
• Oracle
• Sybase Adaptive Server Enterprise
• Other

Username

(JDBC only) Specifies the username the connector uses to log on to the target database endpoint.

Defaults:

Oracle: System

Microsoft SQL Server: sa

DB2: db2admin

Ingres: Ingres

Native

(JDBC and MS SQL Server only) Specifies that MSSQL Native Authentication on Windows is activated. The following is added to the JDBC URL used for the connection:

integratedSecurity=true

Server name

(JDBC only) Specifies the hostname of the database server.

SID

(JDBC and Oracle only) Specifies the Oracle SID.

Port

Specifies the port number the connector uses for communication with the endpoint.

Defaults

JNDI: 389

Oracle: 1521

Microsoft SQL Server: 1433

DB2: 6789

Informix Dynamic Server: 9088

MySQL: 3306

Database

(JDBC only) Defines the database name (most vendors including MS SQL) or its SID (Oracle).

Defaults

Microsoft SQL Server: master

Oracle SID: ORCL

JDBC URL

(JDBC only) Defines the JDBC URL. Connector Xpress automatically forms the URL as you complete the previous fields.

Note: To edit this field, select the Edit check box.

Bind DN

(JNDI only) Defines the distinguished name of the user used to bind to the directory endpoint.

Anonymous

(JNDI only) Specifies that no bind DN is used and instead, an anonymous bind to the directory endpoint is used.

Use TLS

Specifies that Connector Xpress uses TLS connections between Connector Xpress and the endpoint.

Base DN

(JNDI only) Defines the top level of the DIT (Directory Information Tree) you want to manage within the directory endpoint.

Edit

(JDBC only) Lets you edit the JDBC URL field.

Test

Attempts to connect to the specified directory or database using the information provided.

More Information:

Create a Project

Set Up Data Sources