Uploading Data from Databases

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

1. On the "Get data from" page, click 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. Select a method to fetch data when a valid connection is available:
   • If you select fetch data from table, select a table from the displayed Select table list. Click Next to upload data from the selected table.

   • If you select fetch data from SQL, enter an SQL statement in the displayed Enter SQL field to specify a table. Click Next to upload data from the selected table.

10. Select the Store source name check box if you want to upload the source name.
11. Click Next.

Copyright © Cloud Software Group, Inc. All Rights Reserved.