Data Source Registry H

Data Source Registry V

Use this page to Register a Data Source in Common.

To access this page, select Common > Configuration > Data Source Registry in the Navigation pane.

NOTE: Bulk Execution has been enabled on this page. Refer to Use Bulk Execution for more information.

Data Source Registry V

Data Source Registry H

Use this page to Register a Data Source in Common.

Application Data Source Types

Data Services Repository (%)

External System Connection (%)

IG Universal Connect (%)

Local Utility Database (%)

Migration Object Database (dsw%)

Migration Source Database (sdb%)

SAP Application Server (%)

Target System Database (dg%)

Data Services Repository (%) - General

Data Services Repository (%) – Advanced Settings

External System Connection (%) - General

NOTE: The Advanced Settings for the External System Connection type only need to be populated if the data source type is OleDb or ODBC.

Field

Description

Test Connection

Click to test the connection to the data source, which verifies the user ID and password.

Recompile Data Sources

Click to verify the data is available in the database.

NOTE: Objects should only be recompiled for SQL Server databases created for the project. Objects may need to be recompiled a few times. If the recompile fails after three attempts, submit an issue to BackOffice Support.

NOTE: This feature is not used for OleDb and ODBC data source types.

Append Columns

This feature is used for local SQL data sources only.

Click to append the BackOffice reserved columns to all tables in the data source that do not already contain them. The following are BackOffice reserved columns:

  • boaStatus
  • AddedOn
  • AddedBy
  • AddedVia
  • ChangedBy
  • ChangedOn
  • ChangedVia

Refer to Append BOA Reserved Columns to Tables in System Administration for more information.

NOTE: This feature is not used for OleDb and ODBC data source types.

Name

Displays the name of the data source.

Application Data Source Type

Displays the type of data source (for example, an Oracle Database or a Local File). Refer to the Knowledge Base article “How DSP Applications Use Different Data Source Types” on the BackOffice Associates support site (https://support.boaweb.com) for more information.

Active

If checked, the data source is active. If unchecked, the data source is inactive, and system views are not created for the data source.

Data Source Type

Displays the database type of the data source.

Values are:

  • ODBC

  • OleDB

    NOTE: The fields on the Advanced tab are required for the two data source types above.

  • Oracle

  • SqlServer

Server Address

Displays the server address of the data source.

The Server Address combo box contains the server address from data sources registered in the Platform and in Common.

To add a new server address, type the address in this field and click Use this value.

Database

Displays the database name of the data source.

The Database name must be the name of the database exactly as it appears in the database. For Oracle databases, the Database name appears in the TNS name file.

If this field is populated, the Database Instance Name on the Advanced Settings tab must be blank.

User ID

Displays the User ID used to connect to the data source.

Password

Displays asterisks representing the password used to connect to the data source.

Database Settings

NOTE: A user must have access to System Administration to access the pages in this section.

Audit

Click to open the Audit Configuration page in System Administration to enable auditing for specific tables in the database. This icon is only enabled for SQL Server data sources if the data source is protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is checked)

Index

Click to open the Index (Specification) page in System Administration for this data source. This icon is disabled if the data source is not Microsoft SQL Server and it is not protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is unchecked).

Instances

Click to open the Data Source Instances page in System Administration to add, edit and delete instances for the data source

Encryption

Click to open the Data Source Column Encryption page in System Administration to enable or disable encryption for a specific field within a database table. This icon is disabled if the data source is not Microsoft SQL Server and it is not protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is unchecked).

External System Connection (%) – Advanced Settings

NOTE: The Advanced Settings for the External System Connection type only need to be populated if the data source type is OleDb or ODBC.

IG Universal Connect (%) — General tab

Field

Description

Test Connection

Click to test the connection to Boomi using the credentials supplied below. The Boomi Account Name is populated if it does not already exist in the field.

Name

Displays the name of the data source.

Application Data Source Type

Displays the data source type for the application. The naming convention indicated by (%) means that any character can be used in the name.

Boomi API Configuration

Boomi Account Name

Displays the name of the Boomi account.

Click the Test Connection icon in the Page toolbar to populate this field if it is blank.

Boomi Api End Point

Displays the endpoint URL used to call the Boomi AtomSphere API.

Boomi Account ID

Displays the unique identifier for the account.

**NOTE:**This information can be found in Boomi by clicking the active account name > Setup > Account Information.

Boomi User ID

Displays the user ID tied to the Boomi account.

Boomi Password

Displays asterisks representing the password for the Boomi account.

Boomi Default Atom

Displays the atom, the default execution environment where the Process runs.

Each DSP Server has its own atom.

Optional Proxy Settings

Boomi Proxy Server

Displays the URI of the proxy server, if one is used.

Boomi Proxy User Name

Displays the user name for the proxy server account.

Boomi Proxy Password

Displays asterisks representing the password for the proxy server account.

IG Universal Connect (%) — Advanced Settings tab

Local Utility Database (%) - General

Migration Object Database (dsw%) – General

Migration Source Database (sdb%) – General

Target System Database (dg%) – General

Field

Description

Test Connection

Click to test the connection to the data source, which verifies the user ID and password.

Recompile Data Source

Click to verify the data is available in the database.

NOTE: Objects should only be recompiled for SQL Server databases created for the project. Objects may need to be recompiled a few times. If the recompile fails after three attempts, submit an issue to BackOffice Support.

Append Columns

Click to append the BackOffice reserved columns to all tables in the data source that do not already contain them. The following are BackOffice reserved columns:

  • boaStatus
  • AddedOn
  • AddedBy
  • AddedVia
  • ChangedBy
  • ChangedOn
  • ChangedVia

Refer to Append BOA Reserved Columns to Tables for more information.

NOTE: This feature is used for local SQL data sources only.

Name

Displays the name of the datasource.

Application Data Source Type

Displays the type of data source (for example, an Oracle Database or a Local File). Refer to the Knowledge Base article “How DSP Applications Use Different Data Source Types” on the BackOffice Associates support site (https://support.boaweb.com) for more information.

Server Address

Displays the server address of the data source.

The Server Address combo box contains the server address from data sources registered in the Platform and in Common. This list can be used as suggestions where an existing server address can be selected. To add a new server address, type the address in tthis field and click Use this value.

Database

Displays the database name of the data source.

The Database name must be the name of the database exactly as it appears in the database. For Oracle databases, the Database name appears in the TNS name file.

If this field is populated, the Database Instance Name on the Advanced Settings tab must be blank.

User ID

Displays the User ID used to connect to the data source.

Password

Displays asterisks representing the password used to connect to the data source.

System Type

Displays the System Type, which includes the data dictionary, schema and relationship information about external systems used by DSP®. Information captured for System Types includes table and field descriptions, field properties, primary keys, lookup tables, and join relationships.

NOTE: This field displays for the Migration Source Database (.sdb) only.

Database Settings

NOTE: A user must have access to System Administration to access the pages in this section.

Audit

Click to open the Audit Configuration page in System Administration to enable auditing for specific tables in the database. This icon is only enabled for SQL Server data sources if the data source is protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is checked).

Index

Click to open the Index (Specification) page in System Administration for this data source in System Administration. This icon is disabled if the data source is not Microsoft SQL Server and it is not protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is unchecked).

Instances

Click to open the Data Source Instances page in System Administration to add, edit and delete instances for the data source.

Encryption

Click to open the Data Source Column Encryption page in System Administration to enable or disable encryption for a specific field within a database table. This icon is disabled if the data source is not Microsoft SQL Server and it is not protected (i.e., if the Protected check box on the Vertical View of the Data Sources page is unchecked).

Local Utility Database (%) – Advanced Settings

Migration Object Database (dsw%) – Advanced Settings

Migration Source Database (sdb%) – Advanced Settings

Target System Database (dg%) – Advanced Settings

SAP Application Server (%) - General

Use this tab to Establish a Connection to a Target System.

Field

Description

Test Connection

Click to test the connection to the data source, which verifies the database User ID and Password are connected to the database.

Name

Displays the name of the data source.

Application Data Source Type

Displays the type of data source (for example, an Oracle Database or a Local File). Refer to the Knowledge Base article “How DSP Applications Use Different Data Source Types” on the BackOffice Associates support site (https://support.boaweb.com) for more information.

SAP System ID

Displays a three-character alpha-numeric identifier for the SAP System.

Application Server

SAP Application Server

Displays the name of the server where SAP is installed.

NOTE: An Administrator can connect directly to the Application Server using this method. Alternatively, an Administrator can use a Message Server to connect dynamically to the Application Server based on Server resources. Only one type of connection, direct or through a Message Server, can be created for an SAP connection.

Refer to Establish a Connection via a Direct Connection to the Application Server  for more information.

SAP System Number

Displays a two character integer that identifies the SAP instance, used as a parameter in the SAP GUI Logon client when configuring the SAP connection. The SAP System Number displays in SAP on the SAP GUI Change Item screen.

Message Server

SAP Message Server

Displays the name of the message server.

NOTE: Connecting to SAP via a Message Server uses load balancing to manage Server resources. Load Balancing dynamically distribute the SAP users to application server instances when connecting to the Application Server. Only one type of connection, direct or through a Message Server, can be created for an SAP connection.

NOTE: Refer to Establish a Connection via a Message Server  for more information.

SAP Logon Group

Displays the logon group name for the message server if SAP Load Balancing is used to download SAP tables from the source via RFC. Refer to SAP documentation for details about Load Balancing.

Default Credentials

SAP Client

Displays the SAP client number.

SAP Language

Displays the language of the SAP instance and the SAP Language Code.

The language is used when SAP interfaces with the platform and is used when logging in to SAP.

SAP User ID

Displays the user name the connection uses when logging in to SAP.

SAP Password

Displays asterisks to represent the user password the connection uses when logging in to SAP.

User Credentials

Click to open the Data Source Registry User Credentials page to add user credentials to log in to SAP to specific user accounts.

Refer to Add User Credentials to an SAP Connection for a Specific User for more information.

RFC

RFC Functions

Click to open the SAP Connections: RFCs page to view a list of RFCs enabled in the SAP System and a description of each.

The list displays after a user clicks the RFC Extracts icon.

RFC Extract

Click to retrieve a list of all RFCs enabled in the SAP system.

After the extract is complete, click the RFC Functions icon to view the extracted RFCs.

NOTE: RFCs must be extracted before the first BAPI/RFC template type can be created.

Other

SAP Default Connection

If checked, this SAP connection is used by default when posting using the Application Data Source Type of SAP Application Sever (%).

SAP Max Pool Size

Displays a value to specify how many RFC connections are left open for the current user, even if the connections are not being used actively. A pooled RFC connection is allocated much faster than a new connection. Therefore, increasing the pool size minimizes the time needed to get a new connection.

However, if a connection is pooled, it is not available for other users. Typically, ABAP backend systems define an upper limit for the number of RFC connections. If this number has been fully allocated by pooled connections, then new users requesting a new connection may not succeed because the maximum number of connections allowed by the ABAP system has already been allocated.

Typically, the maximum pool size is kept very low and may even be set to 0. If there are substantially fewer concurrent users than the number of concurrent RFC connections to an ABAP system, then increase the pool size to improve performance.

The recommended setting for Max Pool Size is 10 in highly parallel environments.

SAP Application Server (%) - Advanced Settings