Prepare the JDBC Connection String

Also known as the JDBC URL, the JDBC connection string instructs Java-based database tools how to connect to a remote database.

For Data Warehouse, the format of the JDBC connection string is the following:

jdbc:gdc:datawarehouse://secure.gooddata.com/gdc/datawarehouse/instances/{instance_ID}

A JDBC connection remains open for two hours at most. After two hours, the connection is terminated.

Steps:

  1. Review your Data Warehouse instances at the following URL: https://secure.gooddata.com/gdc/datawarehouse/instances  
  2. Click the self link for the Data Warehouse instance to use: 
      
  3. Copy the content of the connectionUrl field. 
      
  4. (Optional) Enable the enhanced logging by adding the log.path parameter to the connection string. See Enable Logging for the JDBC Driver.
  5. Apply the connection string in CloudConnect Designer or the database tool of your choice.