System Administration
Data Source Instances H
Use this page to Add a Data Source Instance.
To access this page in System Administration:
- Click Data Sources in the Navigation pane.
- Click the Instances icon.
|
Field |
Description |
|
Click to test the connection to the Data Source, which verifies the database User ID and Password are connected to the database. NOTE: This option is only available for Data Source Types of SQL Server, Oracle, OLE and ODBC. |
|
|
Recompile Objects |
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 Syniti Support NOTE: When recompiling a data source, SQL inline Table-Valued and CLR functions are not supported. |
|
INSTANCE |
Displays the logical Stewardship Tier "instance" (for example, Dev, QA, or Production) this physical instance of the Stewardship Tier represents. |
|
DATA SOURCE TYPE |
Displays the type of data source. NOTE: This field is auto-populated. The data source type value is determined when the data source is registered. Refer to Register a Data Source for more information. |
|
DATABASE |
Displays the name of the SQL Server database used in this Data Source connection. For Oracle it's the Net Service Name stored in the TNS Names file. |
Data Source Instances V
This page contains the following tabs:
General tab
|
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. NOTE: This option is only available for Data Source Types of SQL Server, Oracle, OLE and ODBC. |
|
Recompile Objects |
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 Syniti Support NOTE: When recompiling a data source, SQL inline Table-Valued and CLR functions are not supported. |
|
Append Columns |
Click to append the Syniti reserved columns to all tables that do not already contain them. The following are Syniti reserved columns:
Refer to Append Syniti Reserved Columns to Tables for more information. |
|
Instance |
Displays the Stewardship Tier instance (for example, Dev, QA, or Production) this physical instance represents. |
|
Data Source Type |
Displays the type of data source. NOTE: This field is auto-populated. The data source type value is determined when the data source is registered. Refer to Register a Data Source for more information. |
|
Connection Settings |
|
|
Server Address |
Displays address of the server this data source connects to. |
|
Database |
Displays the name of the SQL Server database used in this Data Source connection. For Oracle it's the Net Service Name stored in the TNS Names file. |
|
User ID |
Displays the user name used to connect to the data source. |
|
Password |
Displays the password associated with the User ID used to connect to the data source. |
Advanced Properties tab
|
Field |
Description |
|
Protected |
If checked, the data source is protected (as in, read only) and features that make changes to the data source are hidden/disabled (for example, Recompile Objects, Append System Columns, building System Views, indexing, auditing, encryption, and building WebApps). |
|
Connection Properties |
|
|
Port |
Displays the TCP/IP Port to use when connecting to the data source. FTP, HTTP, and databases can use non-default ports for security and management. |
|
Trusted Connection |
If checked, the usage of the User ID and Password fields are bypassed when connecting to the data source. If unchecked, the User ID and Password fields are used to verify the connection. |
|
Connection Timeout |
Displays the number of seconds until the connection times out and the Stewardship Tier displays an error message stating that the connections 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 Syniti Support. |
|
Command Timeout |
Displays the number of seconds until the command times out, the execution of the command fails, and the Stewardship Tier displays a notification about the error. Insufficient command timeouts are the main cause of timeout errors in the Stewardship Tier and this parameter may be increased to a high value to accommodate long-running processes. |
