The DataSelf ETL+ Metadata database is part of ETL+ Server. The metadata provides ETL+ entities with information and execution instructions. For instance, it tells an ETL+ install how to extract transaction data, what tables and columns should be extracted, where the data should be loaded to, and in what extraction schedule.

Data Not Captured in the Metadata

The metadata and ETL+ Server do NOT receive or store the clients' transaction data. The transaction data is securely extracted from source systems and loaded directly into the client’s data warehouse.

Data Captured in the Metadata

The metadata includes the client’s organization name, ETL+ users' credentials, source system names, connection strings to connect to the source systems, a list of mapped tables and columns, ETL SQL Statements to extract data from a client’s source systems, the connection string to the data warehouse.

The following screenshot from ETL+ shows an example of data saved in the Metadata.

  • Data warehouse’s SQL instance and database name = [(local)].[DwTest]

  • Source connection string: source type = MS SQL Server; Server name = (local), Database name= ERP_Database

  • List of tables in the target data warehouse: Account, Account Class, Address

  • List of columns from the Address table: AddressID (int), AddressLine1 (varchar(50)), etc.

  • ETL SQL Statement for the Address table (right panel)

  • Email address of the user currently logged in to ETL+ (see User in lower left corner).

v2022.08 ✅