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.

For most deployments, ETL+ Server is a DataSelf AWS Cloud Service operating 24x7.

Please contact us to discuss our on-premises/private-cloud DataSelf ETL+ Server offer.

Data NOT Captured in the Metadata

The metadata and ETL+ Server do NOT receive 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 shows an example of captured data:

  • 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: 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

v2022.08 ✅