UNIX: Create Region and Cross-Region Data Sources for Azure

Attention: This feature is in Early Adopter Program (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.
Note: We recommend that you use a connection string to connect to Azure databases; that is, using the connect attribute within the database configuration file, which is covered in a later step (Update the Configuration File for Azure Region and Cross-Region Databases).

Use the following steps if you do not intend to use connection strings, but instead create ODBC data sources to access datastore databases.

There are a number of different driver managers that you can use to configure an ODBC data source. These instructions are carried out using unixODBC. If you are using a different driver manager, consult the vendor instructions for creating data sources.

  1. Run the command odbcinst -j command, and note down the location of the drivers configuration file (odbcinst.ini) and the user data sources configuration file (.odbc.ini).
  2. Open the odbcinst.ini configuration file and ensure that you have something similar to the following:

    (This may differ depending on the version of Azure you are running.)

    [ODBC Driver 17 for SQL Server]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1
    UsageCount=1
  3. Open the .odbc.ini configuration file and add an entry for the mandatory data source:
    [<datasource-name>]
    Driver = <driver-name>
    Server = <server-name>
    Database = master
    where:
    • <datasource-name> - a name for the data source.
    • <driver-name> - the name of the driver as configured in the .odbc.ini file; in the example above, that would be ODBC Driver 17 for SQL Server.
    • <server-name> - the name of the server on which the database instance resides.
    • master - the name of the primary configuration database supplied with Azure.
  4. Add a new data source entry for each required datastore:
    [<datasource-name>]
    Driver = <driver-name>
    Server = <server-name>
    Database = MicroFocus$SEE$Files$<datastore-name>
    where:
    • <datastore-name> - the name of the datastore that you want to create.
  5. Save the .odbc.ini configuration file.

Example .odbc.ini file

The following is an example of an .odbc.ini configuration file that contains data sources for an Azure database instance that stores files from the ESDEMO enterprise server region in a region and cross-region database.

[AZ.MASTER]
Driver = ODBC Driver 17 for SQL Server
Server = localhost
Database = master

[AZ.CAS.ESDEMO]
Driver = ODBC Driver 17 for SQL Server
Server = localhost
Database = MicroFocus$CAS$Region$ESDEMO

[AZ.CAS.CROSSREGION]
Driver = ODBC Driver 17 for SQL Server
Server = localhost
Database = MicroFocus$CAS$CrossRegion

Next, you need to update the database configuration file to use the data sources: see Update the Configuration File for Azure Region and Cross-Region Databases .