Data Source tab

You must specify this information on the Data Source tab.
Data Source
The name of the data source defined for the specified Interface Type. Possible scenarios:
  • For Interface service CSV/Excel: The corresponding File, FTP or Amazon S3 data source.
  • For Interface Service Database: The corresponding database data source.
Note: 
  • The filename in the Data Source definition is used only when executing the interface service using a macro.
  • If you are manually importing or exporting data using a file interface service, you must select the file to be used from your local machine.
  • When the Database is used with Interface Direction set to Import and Source set to Table, the data is imported based on the natural order of the table.
  • When Source is set to Query, allowing the use of Order By command, the Market Intelligence events are grouped correctly. The query must be specified as:
    SELECT A as ColumnA,B as ColumnB,C as ColumnC, ROW_NUMBER() OVER (ORDER BY A) as ColumnRowNumber FROM TABLE
  • The query is rejected if specified as:
    SELECT A as ColumnA, B as ColumnB,C as ColumnC FROM TABLE ORDER BY A
Files
The name of the file to be used for the interface service. The files that are displayed are based on the Data Source defined. If the required file is not displayed, you can add the file using + (plus).
Note: 
  • The definition of a File for an interface service of type CSV or EXCEL is used when executing the interface service only using a macro.
  • If the Use File Name Pattern option is set to On, the field label is displayed as File Name Pattern and the regular expression can be used as the file name. These variables are accepted as the file name, with an underscore as a separator:
    • An alpha character (A-Z)
    • An alpha-numeric character (A-Z,0-9
    • A numeric character (0-9)
Use File Name Pattern
Indicates if a specific file name or a pattern is used to find the required file. Possible values:
  • On: The file name is used.
  • Off: A pattern is used.
Note: 
  • If set to On, you can:
    • Include regular expression as the file name
    • Import multiple file
    • Set the order/group the files to import the latest one
  • This option is displayed only if the Interface Type field is set to Import.
Sheet
Determines the sheet of the excel file from/to which the data must be exported or imported.
Note: This field is displayed only for the Interface Type EXCEL.
Field Names in Header Row
Indicates the content of the first row of the file that is imported or exported. If set to On, these are the possible scenarios:
  • When the file is imported, the first row of the import file contains field labels and can be skipped.
  • When the file is exported, the first row of the export file contains the field headers.
Source
Indicates the type of data source interface. Possible values:
  • Table: Tables and Import Filter fields are displayed.
  • Query: Query field is displayed.
Note: For Interface Type Export, the Source field is set to Table.
Table
The database table for which the interface service is applicable.
Import Filter
The SQL text to define the filter criteria for the data passing through the interface service, from the source table.
Note: If not set, all the data of the specified source table is applicable.
Query
The SQL query (up to 4000 characters) used to retrieve the data required for the interface from the specified Data Source.
Note: 
  • You must click Verify to validate the specified query.
  • Full syntax validation occurs on execution of the interface service. For any discrepancy, an error message is displayed from data source, Internal or RDBMS connection.
  • Use the Preview option to view the resultant data of the specified Query after validation. If validation is successful, a pop up is displayed and the application variables in the Query are replaced with the global application variable.