Register a Data Source

During the implementation of Construct, additional Data Sources, other than what are provided in the system, may be required. This use case provides step-by-step instructions and requirements to configure database connection settings for Data Sources utilized by the Syniti Construct.

To register a Data Source in System Administration:

1. Navigate to Admin > Data Sources in the Navigation pane.

2. Click Add.

   View the field descriptions for the Data Sources page.

3. Enter the data source name in the DATA SOURCE NAME field.

4. Select a data source type from the DATA SOURCE TYPE list box.

5. Click Save; the Vertical View displays.

   Note

   The configuration of the Vertical View depends on the Data Source Type selected on the Horizontal View. This example walks through the Syniti Connector Data Source Type.

6. Select a Connector ID from the list box.

7. Click the Advanced Properties tab.

8. Select the Active field.

9. Select the Protected field if the Data Source is Read Only.

10. Enter a value in the Connection Timeout field.

    Note

    The Connection Timeout field denotes how long to wait, in seconds, when connecting to the server before executing any commands. If the server does not reply within this time, the connection action will be canceled.

11. Enter a value in the Command Timeout field.

    Note

    The Command Timeout field denotes how long to wait for a command execution against the server to wait for a reply. If no reply returns in this number of seconds, the action will be canceled.

12. Click Save.

13. Click the Test Connection icon to test the connection to the Data Source, which verifies the database User ID and Password are connected to the database.

14. Click the Recompile Objects icon 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 contact SAP Support using component XX-PART-SYN.

15. Click the Append Columns button to append the Syniti reserved columns used by the Framework to all tables that do not already contain them, a confirmation message displays. Use this option when creating a WebApp on the data source.

    Note

    The following are Syniti reserved columns: AddedBy, AddedOn, ChangedBy, ChangedOn, AddedVia and ChangedVia. If the Protect field is enabled for the assigned server, the tables in the database are not appended with the Syniti reserved columns.

16. Click OK.