Connecting to Data Warehouse from SQL Client Tools

You can connect to Data Warehouse using any SQL client tool. The setup consistent across the tools.

Steps:

  1. Download the Data Warehouse JDBC driver. See Download the JDBC Driver.

  2. Add the Data Warehouse JDBC driver into your tool. For more information, see your tool’s documentation.

  3. Build your Data Warehouse instance’s JDBC connection string. See Prepare the JDBC Connection String.

  4. Set up a connection using the Data Warehouse driver and JDBC connection string. If you are asked for the driver class name, provide the following:

    com.gooddata.datawarehouse.jdbc.driver.DatawarehouseDriver
    

    For additional details, see Access Data Warehouse from SQuirrel SQL.