In this section: |
Before configuring the adapter for Axiom EPM, you must first register the Axiom EPM application (AXIOMCAT) in the catalog path, add the underlying SQL adapter, and add the REST adapter for administration and security information retrieval.
How to: |
Before you can configure the Axiom EPM adapter, the AXIOMCAT application must be created and added to the application path of the server. This can be done through the Web Console.
The Create New Application window opens, as shown in the following image.
The Adapter for Axiom EPM is an enhanced version of the underlying data source adapter. The adapter must be added into the server configuration.
When you add an SQL adapter, there is no need to provide configuration parameters. Instead, these configuration parameters are supplied later when configuring connections to Axiom EPM data sources.
The Web Console provides graphical point and click tools to add and test the adapter.
The Add Adapter to Configuration pane opens.
The adapter is added to your server configuration.
How to: |
The Adapter for Axiom EPM uses REST API calls to obtain metadata and security information from the Axiom EPM environment. To do this, a connection to Axiom needs to be configured.
You can configure the adapter from either the Web Console or the Data Management Console.
or
From the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add REST to configuration pane opens, as shown in the following image.
Enter the following value exactly as shown:
AxiomToken
None
Enter the URL of the machine where the Axiom software is installed in the following format:
http://machine.name.com
Select Password Passthru from the drop-down menu.
Provide the following information:
Additional Chained Authentication Information
Enter the following value in lowercase:
axgettok
Enter the following (including double quotation marks):
"AxiomKey"
The pane should now look like the following image, except for the Base URL, which will reflect an installation value.
How to: Reference: |
Although multiple Axiom EPM connections can be created, the first connection requires slightly different management steps. The reason for this is that before any connections to Axiom EPM data sources can occur, a base layer of application metadata is created and configured. This occurs transparently for the Administrator, but is a slightly different connection management process than when adding additional connections.
To create the first connection:
The Administrator ID is the value that is used as a metadata access key. To access the Web Console, the administrator must know this ID. Users outside of the Web Console do not have metadata access without first logging in to Axiom EPM through this integration.
The Administration - Enter Axiom Admin ID (DBA) opens, as shown in the following image.
Note: This field is only shown when the adapter is first configured.
The Administration - Create a New Axiom EPM Connection window opens.
Note: The Configure button becomes available once the connection test to the selected RDBMS is successful.
Most of the parameters can be changed in the future, but the connection cannot be created without initially supplying correct data source connectivity information. For details on the required information, see Administration - Create a New Axiom EPM Connection Window.
Tip: A worksheet is provided to assist you in gathering the information you will need to type on this screen. For details, see Axiom EPM Connection Worksheet.
Once completed, you may begin managing your new Axiom EPM Connection by adding synonyms.
The Administration - Create a New Axiom EPM Connection window contains the following fields/options:
Is a description that identifies the current server configuration.
Connection Parameters
Is the Data source type. The options are: Oracle and MS SQL Server.
This drop-down box lists available Axiom installations. Select the installation that you will configure. Selecting this value will automatically set the values for the following two options (Server and Database Identifier).
Name of the Database Server (for SQL Server only, not Oracle). This is automatically set by your selection for Axiom Installation.
Is the data source identifier or system data source name. This is automatically set by your selection for Axiom Installation.
Is the RDBMS login ID for data source connectivity. Typically, it is the same login ID Axiom EPM uses to access the data source. There are minimum data access requirements that the ID must have. For details, see Setting Up the Axiom EPM Access ID.
Is a password associated with the access ID.
Is the data source owner identifier or the schema owner depending on your data source. The owner ID is used to fully qualify SQL requests passed to the data source. This allows multiple data source instances or schemas to exist in a single data source. Typical defaults are SYSADM on Oracle and dbo on Microsoft SQL Server.
Synonym Options
Is the name of the synonym to default to when creating new metadata. The options are: Table Name, Table Name with Prefix, Table Name with Suffix.
Note: If you specify any of the options with Prefix or Suffix, the following additional input box is displayed.
Enter the prefix or suffix you wish to prepend or append to the name of the synonym. The maximum length for a Prefix/Suffix is nine characters.
Use the following worksheet to record connection configuration information and keep it for future reference.
Option Name |
Response |
Description |
---|---|---|
Description |
|
Row. |
Administrator (DBA) |
|
Enter the administrator ID and password that has access to all instances and Tables that are required to be administered by the adapter. Must be consistent across multiple connections. |
Database Type |
|
Designation for RDBMS. The options are Oracle and MS SQL Server. |
Axiom Installation |
|
Is the installation that you will configure. Selecting this value from the drop-down list will automatically set the values for the following two options (Server and Database Identifier).
|
Access ID |
|
ID used by Axiom EPM to connect to the RDBMS. |
Access Password |
|
Password associated with the access ID. |
Database Owner |
|
Data source owner ID for the Axiom EPM data source. |
Default Synonym |
|
The name of the synonym to default to when creating new metadata.
Note: If you specify any of the options with Prefix or Suffix, an additional input box is displayed for your Prefix or Suffix entry. |
Prefix/Suffix Default |
|
Enter the prefix or suffix you wish to prepend or append to the synonym name. The maximum length is nine characters. |
WebFOCUS |