Convert native to CDM

Jump to bottom

Anton Ivanov edited this page Feb 22, 2023 · 3 revisions

You can use configured mapping for conversion source database to CDM format, supported database platforms (SQL Server/Azure, PostgreSQL, MySQL, Databricks)

The typical sequence for converting native dataset to the CDM format:

Open or create mapping
Specify source connection string (server name, port, database name, schema name)
Specify CDM connection string (server name, port, database name, schema name)

Connection string examples

SQL Server / Azure

Data type: SQL Server
Server location: servername.database.windows.net
Port: 1433
User name: user
Password: asdfgh1234
Database Name: database_name
Schema Name: dbo

PostgreSQL

Data type: PostgreSQL
Server location: servername.postgres.database.azure.com
Port: 5432
User name: user
Password: asdfgh1234
Database Name: database_name
Schema Name: schema_name

MySQL

Data type: MySQL
Server location: servername.mysql.database.azure.com
Port: 3306
User name: user
Password: asdfgh1234
Database Name: database_name

Databricks

Data type: Databricks
Server location: servername.azuredatabricks.net
Port: 443
HTTP path: sql/protocolv1/o/workspace-id/cluster-id
Password: personal-access-token
Schema Name: schema_name