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, PostgreSQL, and Amazon Redshift.

Procedure

  1. On the project data page, click Export > To database.
  2. If you want to use an existing connection, select a connection from the Saved connections list.
  3. If you want to create a new connection to the database, select Create new connection from the Saved connections list.
    1. Select a JDBC driver from the JDBC driver list.
    2. If you select com.mysql.jdbc.Driver in the enterprise edition, click Upload driver to upload a MySQL driver to TIBCO Clarity.
    3. In the Database URL field, enter the URL of the database that you want to connect to.
    4. In the User name field, enter the user name used to connect to the database.
    5. In the Password field, enter the password used to connect to the database.
    6. In the Login timeouts (sec) field, specify a timeout interval in seconds.
  4. If you want to save the connection, keep the Remember me check box selected. Otherwise, clear this check box.
  5. Click Connect to connect to the specified database.
  6. Select from one of the following options to export project data:
    • Operate existing business objects: select an existing object from the object 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 object.
    • Create new business object: enter an object name to create a new object.

      You can configure the data before exporting the data to the new object. For example, you can choose columns to export, rename the columns, change data types, and set keys for the new object.

  7. Click Export.