Create a GoodData ADS Data Source
Beta Feature
GoodData ADS data source is currently a beta feature and is still under active development. Do not use beta features in your production environment.
GoodData Agile Data Warehouse Service (GoodData ADS) is our data warehousing service developed for GoodData Platform. By creating a GoodData ADS data source, GoodData Platform users can connect their data to GoodData Cloud.
Follow these steps to connect to a GoodData ADS instance and create a GoodData ADS data source:
Refer to Additional Information for information and performance tips about the GoodData ADS data source.
Get ADS Instance ID
To connect to GoodData ADS you need to know its instance ID. You can find the instance ID by accessing the warehouse gray pages, see Reviewing Your Data Warehouse Instances in the GoodData Platform documentation.
The instance ID is part of the connectionUrl
or links
parameters. For example, if your connectionUrl
parameter looks like this:
jdbc:gdc:datawarehouse://secure.gooddata.com:443/gdc/datawarehouse/instances/a991823b54d7eff1d9add3c9b588f
The instance ID is a991823b54d7eff1d9add3c9b588f
.
Create a GoodData ADS Data Source
Once you have configured your ADS user’s access rights, you can proceed to create a GoodData ADS data source that you can then connect to.
Steps:
On the home page switch to Data sources.
Click Connect data.
Select GoodData ADS.
Name your data source and fill in your ADS credentials and click Connect:
Click Save.
Your data source is created!
Steps:
Create a GoodData ADS data source with the following API call:
curl $HOST_URL/api/v1/entities/dataSources \ -H "Content-Type: application/vnd.gooddata.api+json" \ -H "Accept: application/vnd.gooddata.api+json" \ -H "Authorization: Bearer $API_TOKEN" \ -X POST \ -d '{ "data": { "type": "dataSource", "id": "<unique_id_for_the_data_source>", "attributes": { "name": "<data_source_display_name>", "url": "jdbc:ads:https://<ADS_HOST>:443/<ADS_DBNAME>", "schema": "<ADS_DBNAME>", "type": "ADS", "username": "<ADS_USER>", "password": "<ADS_PASSWORD>" }}}' | jq .
If you want to specify a custom resource pool, add
?resource_pool=<RESOURCE_POOL>
to the url.To confirm that the data source has been created, ensure the server returns the following response:
{ "data": { "type": "dataSource", "id": "<unique_id_for_the_data_source>", "attributes": { "name": "<data_source_display_name>", "url": "jdbc:ads:https://<ADS_HOST>:443/<ADS_DBNAME>", "schema": "<ADS_DBNAME>", "type": "ADS", "username": "<ADS_USER>" } }, "links": { "self": "$HOST_URL/api/v1/entities/dataSources/<unique_id_for_the_data_source>" } }
Additional Information
Ensure you understand the following limitations and recommended practice.
Data Source Details
Typical JDBC URL may look like this:
jdbc:gdc:datawarehouse://<host>:<port>/gdc/datawarehouse/instances/<instanceId>
For specification of custom resource pool, use ?resource_pool=new_pool
.
Unsupported Features and Beta Limitations
Make note of the following limitations:
- Each
SELECT
statement can fetch max 10,000 records.