Modify Configuration of Data Source Table Columns

Data Source tables can either be modified or directly added or deleted from Collect.

To modify the configuration of data source table columns:

  1. Click Targets in the Navigation pane.

  2. Click Sources for a target.

  3. Click Schedule Groups for a source.

  4. Click Tables for a schedule group.

  5. Click Vertical View for a table.

  6. Click General Information tab.

  7. Click View Design.

  8. Click Column Count for a data source table.

  9. Click Edit for a column to modify the data source table column.

    Or

    Click Add to add a new column to the data source table.

    View the field descriptions for the Data Source Table Columns page’s Vertical View

  10. Enter column name converted to the defined data type and loaded into the target table in Column field.

  11. Enter the data type of the source column in From Data Type field.

  12. Enter the data length of the source column in From Data Length field.

  13. Enter the data precision (total number of digits) of the source column in From Data Precision field.

  14. Enter the data scale (number of digits after the decimal point) of the source column in From Data Scale field.

  15. Enter the nullable flag of the source column in From Nullable field.

  16. Enter the data type to create tables in the database in Table Create Data Type field.

  17. Enter the data type of the target column in To Data Type field.

  18. Enter the data length of the target column in To Data Length field.

  19. Enter the data precision (total number of digits) of the target column in To Data Precision field.

  20. Enter the data scale (number of digits after the decimal point) of the target column in To Data Scale field.

  21. Enter the nullable flag of the target column in To Nullable field.

  22. Enter the source system SQL function or command to download data from the source in Column Override field.

    NOTE: The Column Override field allows for source system function commands to be overridden when data is loaded into the target SQL server tables, for example, TO_CHAR(ORDER_TIMESTAMP,’YYYYMMDD’) as Order_Timestamp.

  23. Click Save.