Uploading Data from a Database

You can upload your data from a database to TIBCO Clarity. TIBCO Clarity supports the following databases: DB2, Oracle, Microsoft SQL Server, MySQL, PostgesSql, and Amazon Redshift.

Procedure
1. On the "Get data from" page, click Database.
2. In the "Import from database" dialog, 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 and Password fields, enter your user name and password used to connect to the database.
   5. In the Login timeouts (sec) field, specify a timeout interval in seconds.
      The default value is 10.
4. If you want to save the connection, keep the Remember me check box selected. Otherwise, clear this check box.
5. Click Connect.
6. Select a method to fetch data when a valid connection is established:
   From table: select a table from the displayed Select table list. If you want to upload the source name, select the Store source name check box.

   Use SQL: enter an SQL statement in the displayed Enter SQL field to specify a table.

7. Click Next.