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 Datastores).
Use the following steps if you do not intend to use connection strings, but instead create ODBC data sources to access datastore
databases.
-
Open the ODBC Data Source Administrator.
Tip: On most newer Windows versions, click the Start Menu button, type
ODBC, and then select the appropriate desktop app.
-
On the
ODBC Data Source Administrator dialog box, select the
System DSN tab.
-
Add the mandatory data sources:
Note: In order to create or query databases, you must have an active data source connection to the
master database (the primary configuration database supplied with Azure). If this data source already exists, you can skip this
step.
-
Click
Add.
-
Select the appropriate ODBC driver for your database (for example,
ODBC 17 for SQL Server is a common one for Azure SQL), and click
Finish.
Note: The bitism of your driver must match the bitism of the application that will use it.
The
Create New Data Source... wizard appears.
-
Enter a name and description for the data source, and the name of the server on which the database will reside.
-
Click
Next twice.
-
Select the
Change the default database to: option, and enter
master.
-
Click
Next, and then click
Finish.
An overview of the data source details is displayed.
-
Click
Test Data Source.
The connection should be successful; if not, it indicates that you have a problem with your Microsoft SQL Server installation,
and should consult the vendor instructions to troubleshoot before proceeding any further.
-
Click
OK twice.
-
Add a new data source for each required datastore:
-
Click
Add.
-
Select the appropriate ODBC driver for your database (for example,
ODBC 17 for SQL Server is a common one for Azure SQL), and click
Finish.
Note: The bitism of your driver must match the bitism of the application that will use it.
The
Create New Data Source... wizard appears.
-
Enter a name and description for the data source, and the name of the server on which the database will reside.
-
Click
Next twice.
-
Select the
Change the default database to: option, and using the datastore-specific notation, enter a database name:
MicroFocus$SEE$Files$<datastore-name>
where
<datastore-name> is the name of the datastore that you want to create.
-
Click
Next, and then click
Finish.
An overview of the data source details is displayed.
Note: As the database does not yet exist, you will not be able to test the data source: do not click
Test Data Source.
-
Click
OK.
The ODBC Data Source Administrator appears again.
-
Repeat these sub-steps for each additional datastore you require.
-
Click
OK.
The data sources for the datastore databases are configured. You now need to update the database configuration file to use
the data sources: see
Update the Configuration File for Azure Datastores.