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.
Currently, ODAS requires that the database server that HMS is on is also where all other ODAS databases will be stored.
The following configuration settings are used to configure the connection to an existing HMS:
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: