Exporting Data to a Database

You can export project data to an existing table or a new table in a database. The supported databases are Oracle, Mysql, SQLServer, and PostgreSQL.

Procedure

  1. On the project data page, click , and then click Export project > To database.
  2. In the Import form database dialog, select a JDBC driver from the JDBC driver list.
  3. If you select com.mysql.jdbc.Driver in the enterprise edition, click Upload driver to upload a MySQL driver to TIBCO Clarity.
  4. In the Database URL field, enter the URL of the database that you want to connect to.
  5. In the User name field, enter the user name used to connect to the database.
  6. In the Password field, enter the password used to connect to the database.
  7. In the Login timeouts field, specify a timeout interval (in seconds).
  8. Click Connect to connect to the specified database.
  9. Click Next when a valid connection is established.
  10. Select from one of the following options to export project data:
    • Using existing table: Select an existing table from the table name list. You can select whether you want to override the existing data or not when the new data contains the same key as in the existing table.
    • Create new table: Enter a table name to create a new table.

      This option allows you to configure the data before exporting the data to the new table. For example, you can choose columns to export, rename the columns, change data types, and set keys for the new table.

  11. Click Finish to export your data.
Contents
Search Results