Data Source tab

Use this tab to select the data source for an interface type.

You must specify this information on the Data Source tab:

Data Source
The name of the data source. Selected from a list of values defined for the specified interface type.
Table or Query
Indicates whether a query or a database table is specified for the interface.
Note: By default, this value is set to Table if Interface Direction is set to Export.
Tables
The database table for which the interface service is applicable.
Note: 
  • This field is displayed only when Data Source is set to Table.
  • You can specify the table name manually if the database data type is set to DataLake.
  • Validation is not performed, if the database data type is set to DataLake.
Import Filter
The SQL query to define the filter criteria for the data passing through the interface service, from the selected table.
Note: 
  • This field is displayed only if Data Source is set to Table and Interface Direction is set to Import.
  • The text must be specified in the standard SQL format.
  • The context in SCP can be filtered using the variables. For example, PERIOD >= %horizon-start% AND PERIOD <= %horizon-end%.
Query
The SQL query (up to 4000 characters) used to retrieve the data required for the interface from the specified Data Source.
Note: 
  • This field is displayed only if Data Source is set to Query and Interface Direction is set to Import.
  • You can validate the specified query using the Verify option.
  • Full syntax validation occurs on execution of the interface service. An error message is displayed from the RDBMS data source in case of a discrepancy.
  • The Query processing time is limited to 10 minutes. If the query processing time exceeds, this error message is displayed:
    ‘An Error occurred. The Query has timed out’.

You can use the Preview option to view the resultant data of the specified Query. In addition, the Query is validated when you select the Preview option. If validation is successful, a pop-up is displayed and the application variables in the Query are replaced with the planning engines application variables.

Note: 
  • This option is displayed only when the source is set to Query.
  • This option initially validates the text specified in the Query field using the Verify option.
  • The grid cannot be modified and contains vertical and horizontal bars, to allow visibility of the returned data and cannot be filtered or sorted.
  • The Preview processing time is limited to 10 minutes. If the preview processing time exceeds, this error message is displayed: 
    'An Error occurred. The Query has timed out'.