Add a secondary source
Adding a secondary database source is the first step in configuring a database connectivity fail-over recovery. Using error-handling rules, the system can switch between the primary and secondary database tables in case of system network error or database connectivity failure. Database fail-over is intended for download requests from read-only databases. When database fail-over occurs, records on the secondary database are available for use with download requests. This function is not available for System Tables.
Prerequisite: The non-system database table for which you are adding a secondary source must have already been created and registered.
To add a secondary database source, complete the following steps in Advanced Inventory Platform Manager.
-
Go to Develop > Table Registration.Expected ResultResult: The Registered Tables page displays a list of the tables you are allowed to view in the default environment.
-
Optional. Select another environment from the dropdown.
-
In the table list, locate the table for which to add a secondary source and select it.
-
On the Registered Tables page, select Add Secondary Source.
-
Under Verify Connection String, choose the database for which to register a table, or select Add New to build a new database connection string. Complete one of the following tasks.
-
If verifying an existing connection string, select the connection string. The connection string appears in the box.
-
If adding a new connection string, the Build Connection String box appears. To build a connection string, complete the following substeps.
-
Enter an ID for the connection string.
-
Enter a Description for the connection string.
-
Do one of the following:
-
For only one environment, go to the next step.
-
For multiple environments, choose the environment in which to create the database connection string.
-
-
Select the appropriate provider.
-
Select Next.
-
Enter the required values, which are specific to the database software. For information, see the system administrator or refer to database documentation.
-
Select Next.
-
Enter the schema name.
-
Select Finish.
-
Expected ResultResult: The connection string appears in the box. It is also added to the Database Connection Strings in Admin > Configuration. -
-
After the selected connection string displays, select Next.
-
Select Finish.
Postrequisite: Optional. To see the tables that were registered, choose the environment to which the tables were registered.
Loading...
There was a problem loading this topic