GoodData.CN & Vertica

GoodData.CN, the best analytics stack, with the unlimited power of the columnar Vertica database — start for free.

The best way to build cloud-native self-service analytics on top of your Vertica database, using your infrastructure

Vertica analytical data warehouse

Vertica’s high-performing, highly scalable data warehouse with advanced analytics and machine learning addresses the most demanding analytical use cases.

Agile continuous delivery

All elements of your analytics can be versioned, merged, automatically tested, and rolled out to production. Designed for DataOPS everyday needs.

Self-service analytics tools

Easy-to-use analytics tools and visuals, such as dashboards and insights, manageable by non-technical users.

GoodData.UI
SDK

Powerful SDK, for creation of data applications, that works with front-end frameworks, such as React, Angular or Vue as well as with pure JavaScript.

Built‑in multi‑tenancy

Secure analytics for your internal teams and external business partners.

Data sampling

Explore trends in large data volumes that contain billions of records — just by analyzing a sample of the data.

Approximate functions

Speed up performance by approximating results of custom metrics.

Get started in five minutes

Install

Spin up an All-In-One Docker image from Docker Hub.

$ docker run -i -t -p 3000:3000 -p 5432:5432 -v gd-volume:/data \
gooddata-cn-ce:latest

Connect your Vertica data source

Connect your Vertica database by the following command on Linux or in Powershell.

Read more about how to connect a data source in documentation.

curl http://localhost:3000/api/entities/dataSources \
-H "Content-Type: application/vnd.gooddata.api+json" \
-H "Accept: application/vnd.gooddata.api+json" \
-H "Authorization: Bearer YWRtaW46Ym9vdHN0cmFwOmFkbWluMTIz" \
-X POST
-d '{
	"data": {
		"attributes": {
			"name": "Vertica datasource",
			"url": "jdbc:vertica://<vertica_db_host>:<vertica_port>/<vertica_db_name>",
			"schema": "<schema>",
			"type": "VERTICA",
			"username": "<your_vertica_user>",
			"password": "<your_vertica_user_password>"
		},
		"id": "vertica-datasource",
		"type": "dataSource"
	}
}'

Invoke-RestMethod -Method Post -Uri 'http://localhost:3000/api/entities/dataSources' `
 -ContentType 'application/vnd.gooddata.api+json' `
 -H @{
   'Accept' = 'application/vnd.gooddata.api+json'
   'Authorization' = 'Bearer YWRtaW46Ym9vdHN0cmFwOmFkbWluMTIz'
 } `
 -Body '{
	"data": {
		"attributes": {
			"name": "Vertica datasource",
			"url": "jdbc:vertica://<vertica_db_host>:<vertica_port>/<vertica_db_name>",
			"schema": "<schema>",
			"type": "VERTICA",
			"username": "<your_vertica_user>",
			"password": "<your_vertica_user_password>"
		},
		"id": "vertica-datasource",
		"type": "dataSource"
	}
}'