Connecting to an Existing HMS¶
It is possible to configure ODAS to connect to an existing HMS. This will allow ODAS to automatically see all existing metadata in your catalog without having to register it again.
The following HMS versions are supported:
- HMS 1.x
- HMS 2.3
If you have a different HMS version, please contact Okera support.
Note
Currently, ODAS requires that the database server that HMS is on is also where all other ODAS databases will be stored.
Configuration Settings¶
The following configuration settings are used to configure the connection to an existing HMS:
CATALOG_DB_ENGINECATALOG_DB_URLCATALOG_DB_USERCATALOG_DB_PASSWORDCATALOG_DB_HMS_DBENABLE_HMS_2_SCHEMA
Configuring the Connection to an Existing HMS¶
To connect to an existing HMS, you will need to know the database server details where it is located. This follows the same instructions as when configuring a database.
For example, if your existing HMS is at hms.example.com:3306 with a username/password of hms/SecretPassw0rd! and the HMS database name is my_hms_db, the configuration will look like this:
CATALOG_DB_ENGINE: mysql
CATALOG_DB_URL: hms.example.example:3306
CATALOG_DB_USER: hms
CATALOG_DB_PASSWORD: SecretPassw0rd!
CATALOG_DB_HMS_DB: my_hms_db
HMS v2 Schema¶
HMS v1 and v2 have different database schemas, and ODAS needs to be configured on which one to use. By default, ODAS uses the HMS v1 schema.
To set ODAS to use the HMS v2 schema (only do this if your HMS is 2.0 or higher), set the following in your configuration file:
ENABLE_HMS_2_SCHEMA: "true"