Description

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

Displays the name of the data source.

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.

Displays an icon if there was a change made to the data source on the System Administration Data Sources page.

The user can either:

• Apply the updates made to the data source in Common to the data source in System Administration by validating or saving the record in Common

• Apply the updates made to the data source in System Administration to the data source in Common manually

Refer to Sync Data Sources in Common and System Administration for more information.

Click to open the Data Sources page in System Administration to view changes entered in System Administration for the selected data source.

NOTE: A user must have permission to access the Data Sources page in System Administration.

Description

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

Displays the name of the data source registry.

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.

Displays a description of the data source.

If checked, the selected Data Services repository is the default Data Services connection for various automated processes. There is only one default Data Services connection.

Displays the server address of the Data Services server.

Displays the URL to the Data Services web service.

NOTE: URL supports both http and https.

Displays the name of the Data Services repository.

Displays the type of Authentication used to connect to Data Services.

Displays the user name used to connect to Data Services.

Displays the password used to connect to Data Services.

If checked, Web Services Authentication is required to connect to this Instance of Data Services. If unchecked, Web Services Authentication is not required.

Description

Displays the length of time in seconds that a command can run before timing out. This value is configured via a Data Source registry entry for the Data Services calls for RFC Download Packages. If the field is blank, the timeout is set to 300 seconds.

NOTE: The recommended setting for the Command Timeout field is 600.

Description

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

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.

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.

Displays the name of the data source.

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.

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

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

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.

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.

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

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.

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)

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).

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

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).

Description

Displays the number of seconds until the connection times out and the DSP® displays an error message stating that to wait before considering the connection failed. Generally, this value does not need to be changed to a value higher than 30 seconds, and adjustment to values above that should be made after checking with BackOffice Product Support.

Displays the number of seconds until the command times out, the execution of the command fails, and the DSP displays a notification about the error. Insufficient command timeouts are the main cause of timeout errors in DSP and this parameter may be increased to a high value to accommodate long running processes.

Displays the type of database to connect to. This is required if the database type is ODBC or OleDB.

If checked, if the Server is configured to connect using Windows Authentication, the connection will use the hosting machine’s information to authenticate the connection and bypass the usage of the User ID and Password fields.

Displays the Data Source Name (DSN) parameter, which can be used when the connection to the data source is not a SQL server connection. It is used primarily when defined by the web server control panel, or if the SQL server connection requires additional special parameters not supplied by the DSP standard connection.

This field is not used.

This field is not used.

Displays the connection string for this data source.

Displays the DataSourceID used for auditing.

Displays the port number of the connection.

Some databases can be configured to run on the non-default port. The Port field allows users to enter the server that uses a different port. Also, the Port field is used for FTP connections to define the target port.

If checked, the Data Source is protected (as in, read only) and features that make changes to the Data Source are hidden/disabled (e.g., Recompile Objects, Append System Columns, building System Views, indexing, auditing, encryption, and building WebApps).

Displays the name of the database instance. For Oracle it's the SID. If this field is populated, the Database field on the General tab must be blank.

Displays the prefix for the procedure parameter name. To prevent conflicts with table/view column names when writing a stored procedure, parameters are usually prefixed. By registering this prefix at the data source level, DSP will add the prefix to the column name when passing parameters to a stored procedures.

If checked, Systems Views are created in the data source by DSP. System Views are views that are installed by the Platform in a data source that links back to certain tables or views in the CranSoft database.

This feature is often used for advanced WebApp development.

If unchecked, Systems Views are not created in the data source by DSP®.

This field is not used.

Description

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.

Displays the name of the data source.

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

Displays the name of the Boomi account.

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

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

Displays the unique identifier for the account.

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

Displays the user ID tied to the Boomi account.

Displays asterisks representing the password for the Boomi account.

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

Each DSP Server has its own atom.

Optional Proxy Settings

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

Displays the user name for the proxy server account.

Description

Displays the maximum time in seconds that the Boomi Process can run before returning a status. After this time passes with no response, a timeout error occurs and the Process stops.

The default value is 100 seconds.

Description

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

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.

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.

Displays the name of the datasource.

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.

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.

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.

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

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

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.

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).

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).

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

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).

Description

Displays the number of seconds until the connection times out and the DSP displays an error message stating that the connection failed. Generally, this value does not need to be changed to a value higher than 30 seconds, and adjustment to values above that should be made after checking with BackOffice Product Support.

Displays the number of seconds until the command times out, the execution of the command fails, and the DSP displays a notification about the error. Insufficient command timeouts are the main cause of timeout errors in DSP and this parameter may be increased to a high value to accommodate long running processes.

If checked, if the Server is configured to connect using Windows Authentication, the connection uses the hosting machine’s information to authenticate the connection and bypass the usage of the User ID and Password fields.

Displays the Data Source Name (DSN) parameter which can be used when the connection to the data source is not a SQL server connection. It is used primarily when defined by the web server control panel, or if the SQL server connection requires additional special parameters not supplied by the DSP standard connection.

Displays the name of the database instance. For Oracle it's the SID. You must leave the Database field blank to use this feature.

If this field is populated, the Database field on the General tab must be blank.

If checked, the Platform injects specific system views into the database. This feature is often used for advanced WebApp development.

System Views are views that are installed by the Platform in a data source that link back to certain tables or views in the CranSoft database.

Description

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

Displays the name of the data source.

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.

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

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.

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

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.

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

Displays the SAP client number.

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.

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

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

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

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.

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

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

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.

Description

Displays the data source remote file type that must be used for asynchronous postings for user defined templates. Files must be physically transferred to the SAP system via FTP, UNC or HTTP for these posting types.

If checked, the platform uses the namespace version of the BOA Function Module. If unchecked, the platform uses the non-namespace version of the BOA Function Module.

NOTE: The namespace concept describes how customers and partners name their development objects to avoid overlapping when SAP software is upgraded. BDC Function Modules and BAPI Function Modules can be namespace or non-namespace objects.

If checked, data is downloaded in Collect for all clients in the SAP instance. This setting is used for RFC and SAP Text data downloads when more than one SAP client is required to download data.

If unchecked, data is downloaded for the client associated with this data source only.

If checked, builds primary keys without the client field (usually MANDT). This feature can be used if only 1 client is downloaded (as in, the All Clients check box is unchecked) for RFC and SAP Text data downloads.