Data Source Registry H
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
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
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.