[et_pb_section][et_pb_row][et_pb_column type=”1_4″][et_pb_sidebar admin_label=”Sidebar” orientation=”left” area=”et_pb_widget_area_1″ background_layout=”light” /][/et_pb_column][et_pb_column type=”3_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]

Create a Source System Record

[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]

In addition to a Connection Manager, a Source System record needs to be created. The Source System record contains information about the nature of the Source system.

The most important aspect of creating a Source System record is to define a ‘Source System Abbreviation’. The ‘Source System Abbreviation’ is used to prefix table names in the Staging database. This ensures there is no naming conflict when staging tables with the same name from more than one Source System.

Without a Source System, a Staging table can’t be defined, and the Source System won’t appear in the Sources tool window.

To Create a Source System, right click the Source Systems folder in the Solution explorer and click Create New. The following dialog appears.

[/et_pb_text][et_pb_image admin_label=”Image” src=”https://www.dimodelo.com/wp-content/uploads/source-system-dialog.png” alt=”Source System Dialog” title_text=”Source System Dialog” show_in_lightbox=”off” url_new_window=”off” animation=”left” sticky=”off” /][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]

  • Source System Name. Give the source system a unique name. This is the name that appears in the Solution Explorer.
  • Source System Abbreviation. Give the Source System a two or three letter abbreviation that is unique within the project. The ‘Source System Abbreviation’ is used to prefix table names in the Staging database. This ensures there is no naming conflict when staging tables with the same name from more than one Source System.
  • Platform, Data Format and Update Frequency. These are purely informational. They have no impact on generation.
  • Connection. Associate the Source System with one of the existing Connection Managers. This is mandatory.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]