Migrate Data Sources from Native Connectors to OCF
Alation APIs can be used to migrate RDBMS data sources from built-in (native) connectors to OCF connectors in bulk. This method can be used for both Alation Cloud Service and on-premises instances of Alation. To see other options for migrating as well as general information about migration, see Migration from Native to OCF Connectors.
After migrating to OCF connectors, you will need to start using v2 of the Data Sources API to interact with your data source via API.
Irreversible
The migration process is irreversible and cannot be undone.
To migrate from native to OCF connectors using the API:
- Make sure that the required OCF connector has been installed and is available on the Alation server by going to Admin Settings > Server Admin > Manage Connectors. The Manage Connectors page displays all OCF connectors currently available on the Alation server. On this page, locate the OCF connector you are migrating to.
- If the OCF connector hasn't been installed yet, you will need to obtain the OCF connector from the Alation Connector Portal, then install the OCF connector on your Alation instance. See Manage Connectors for help with installation.
- Get the ID of the OCF connector by going to Admin Settings > Server Admin > Manage Connectors, then selecting the desired OCF connector. The connector's ID is shown in the URL in your browser's address bar. For example, if the URL of the connector page is
https://{your-alation-instance}/admin/connect/123/
, the connector's ID is123
. You will need this ID to make the API call. - Determine the ID of the database type you are migrating from. This is shown under the Native Connector Database Type ID column in the table below. You will need this ID to make the API call.
- (Optional) Determine the IDs of any data sources that you don't want to migrate to the OCF connector. See How to Find Data Source ID for help.
- Refer to the API reference for [Bulk migrate data sources to OCF] to construct the API call.
Connector Database Type IDs
Native Connector Name on UI | Native Connector Database Type ID | Equivalent OCF Connector |
---|---|---|
Azure SQL Data Warehouse | AZUREDW | Synapse OCF Connector |
Google BigQuery | BIGQUERY | Google BigQuery OCF connector |
DB2 | DB2 | DB2 OCF Connector |
Databricks | DATABRICKS | Databricks OCF Connector |
Greenplum | GREENPLUM | Greenplum OCF connector |
Hive2 | HIVE2 | Hive OCF Connector |
Impala | IMPALA | Impala OCF Connector |
MemSQL | MEMSQL | MemSQL OCF Connector |
MySQL | MYSQL | MySQL OCF Connector |
Oracle | ORACLE | Oracle OCF connector |
PostgreSQL | POSTGRESQL | PostgreSQL OCF Connector |
Redshift | REDSHIFT | Redshift OCF Connector |
SAP Hana | SAP | Saphana OCF connector |
SAS | SAS | Sas OCF connector |
Snowflake | SNOWFLAKE | Snowflake OCF connector |
SQL Server | SQLSERVER | SQL Server OCF Connector |
Sybase IQ | SYBASE | SybaseIQ OCF Connector |
Sybase ASE | SYBASEASE | SybaseASE OCF Connector |
Teradata | TERADATA | Teradata OCF Connector |
Vertica | VERTICA | Vertica OCF conne |
Updated 12 months ago