Creating a Database Target
Use the Target Definition Wizard (via Central > Targets, New) to create a Database target providing all the necessary parameters.
- In Central > Targets, click the New icon, to manually create a new Database target n the Target Definition Wizard.
- Select Database and then click Next.The Define the Database Target page appears in the wizard.
- Enter the target name and select the RDBMS to use from the drop-down. For example, to connect to a PostgreSQL database on the same server running CloudTest, select PostgreSQL.
- Provide a host name and port.
- Provide a catalog name (optional).
- Enter the database user name and password credentials to use.The Target Definition Wizard will construct your JDBC URL based on the information provided here.Targets can also be defined and edited within the Target Editor. Consider the following information in making any changes or during troubleshooting database connections.A PostgreSQL database requires the following Database URL format:
jdbc:postgresql://<database_server_host>:<port_number>/<database_name>Refer to the PostgreSQL online documentation for more details.A Microsoft SQL Server database requires the following Database URL format:
jdbc:sqlserver://[databaseServerHost[\databaseInstanceName][:portNumber]][;<property>=value[;<property=value>]] <property=value>]]The database name is specified by the property "databaseName". Refer to the Microsoft online documentation for more details.An Oracle database requires the following Database URL format:
jdbc:oracle:thin:@:<port_number>:<database_name>Refer to the Oracle database documentation for more information.Note: The database user name and password can be embedded in the database URL for some databases such as Oracle and Microsoft SQL Server. But, they are overridden by the user name and password entered on the Target Editor. So, users should not put the user name and password in the database URL.The Target Definition Wizard, Advanced tab presents the same information only in the style that it is also presented in the Target Editor. Use this to inspect the JDBC URL in cases where it exceeds the display in the Basic tab.
- Click Next to view the Summary page.
- Double check the database URL, ensuring that the URL form is correct. Click Finish to complete creation of the database target. The target will open in the Target Editor.
What you should see
Once completed, you can click Test Connection in the Target Editor to ensure the target definition has been satisfactorily completed. If the connection is unsuccessful, check the JDBC URL, ensure that the database is running, try increasing the Connection Timeout and/or the Execution Timeout for the new target. and then refer to the Troubleshooting section below.