Predefined Sources and Targets

Predefined Sources and Targets #

While working with ETL data_snake, the system administrator should provide you a list of predefined Sources and Targets. This is necessary to ensure that correct data is extracted and existing data will not be unnecessarily modified.

It is possible to create Ad Hoc Sources and Targets in the Modeler, but they will not be saved for later use.

To add Sources and Targets, the system administrator must navigate to Data sources or Data targets and modify existing predefined options by either Adding new predefined elements…

…or editing existing ones by clicking the icon next to specific elements on the list.

To delete a Source or Target, click the icon next to the specific element.

Before deleting a Predefined Source or Target, you will see a confirmation screen. If the Predefined Source or Target was used in any Modifier, you will see a list of all Modifiers that will become invalid after you delete the Predefined Source or Target.

To see if you configured a Source or Target correctly, you can click the icon on the list, or the Test button in the Details section of a Predefined Source or Target.

The Last connection status column shows whether the last connection with the Predefined Source or Target was a success (), a failure () or the connection has not yet been tested ().

Clicking a Connection status will open a pop-up window with details of the last connection to that Predefined Source or Target. There you can see:

  1. the Connection name,
  2. the Connection driver,
  3. the Status of the connection,
  4. the Date the connection was tested,
  5. A table with Errors (if there were any) containing:
    • A - the error Code,
    • B - the Response status,
    • C - the Response content,
    • D - the Error message,
  6. the Stack trace for the error (if there were any),
  7. the Show whole history button.

Clicking the Show whole history button will navigate you to a list of all connection statuses, where you can see:

  1. the Predefined Source or Target name,
  2. the connection log’s ID,
  3. the Created date of the connection log,
  4. the Status of the connection and actions; when you click the status, it will display that connection’s log.

On the list of Predefined Sources or Targets you can also filter the visible elements using the filters above the list.

Sources #

To add Sources, the system administrator must navigate to Data sources and either modify existing predefined options by Adding new predefined elements…

…or editing existing ones by clicking the icon next to specific elements on the list. Each Predefined Source can also have a description.

The available sources are:

  1. Oracle Database
  2. Postgres Database
  3. MySQL Database
  4. Microsoft SQL Server Database
  5. Microsoft Access
  6. ODBC Database
  7. Excel
  8. CSV
  9. SDMX-ML
  10. Fusion Registry 10
  11. Script

Targets #

To add Targets the system administrator must navigate to Data targets and either modify existing predefined options by Adding new predefined elements…

…or editing existing ones by clicking the icon next to specific elements on the list. Each Predefined Target can also have a description.

The available targets are:

  1. Oracle Database
  2. Postgres Database
  3. MySQL Database
  4. Microsoft SQL Server Database
  5. Excel
  6. CSV
  7. Fusion Registry 10
  8. Script