DataSelf ETL

DataSelf ETL Introduction

DataSelf ETL simplifies the deployment and maintenance of MS SQL data warehouses. With it, users can avoid the use of SSIS and stored procedures to work with data warehouses. Via user-friendly wizards, users will be able to import tables, create indexes, relationships and formulas in a fairly code-free environment. DataSelf ETL communicates with MS SQL via ADO and SQL Server Native Client OLE DB provider.

DataSelf ETL and Data Warehouse Overview 15-min Video

https://www.youtube.com/watch?v=IZaHgBPw8nk

Using the DataSelf ETL Configuration GUI

The ETL Configuration GUI is identified by this icon:

Under construction: Put image of main window here. Add name of program .exe. / ETL Config GUI

"Site Map" for ETL Related Pages

Built-in & On-line Help

ETL menu bar: Help > Online help

Or see ETL Help file at http://www.dataself.com/dsbi/docs/dsetlhelp2009a.htm

Online help page on Importing from Excel Files: http://www.dataself.com/dsbi/docs/ETLExcelImport.htm

ETL Workflows

Procedural / How-to instructions. A good place to start to understand how the various wizards work together. These workflows are a kind of topical table-of-contents for the more detailed sections of documentation.

Workflows on how to:

• Import a table. Import a table from a source database into the DS data warehouse.
• Import a table with a filter. Add filter criteria to the imported table.

ETL MetaData Reports

ETL metadata includes information about import mappings, data sources, data warehouse fields, filters, formulas (calculations), summary operations, relationships, and indexes. See Print Metadata and Print All Metadata on the right-click menu of the Browse Table window to generate reports.

ETL Wizards

Wizard Icons from the Icon toolbar (upper left hand corner of ETL window).

See ETL Wizards page for details.

Browse Table window (ALT-T)

The Browse Table window is the ETL's default operational window. Many ETL tasks and workflows start from here.

Browse Data windows

Navigation: Double-click on any table name in the Browse Table window.

The so-called "browse data" windows display the data stored in the data warehouse tables listed in the Browse Table window.

---

Right-click on Browse Table window

Browse Table - Right-click Menu

Right-click on any row in the Browse Table window.

Print Metadata

Navigation: Right-click on a table name in the Browse Table window, click Print Metadata.

Modify Import/Mapping window (Ctrl-I)

Navigation: Right-click on a table name in the Browse Table window, click Modify Import/Mapping.

Modify Import/Mapping invokes a subset of the Import Table Wizard. Used to modify the mappings of existing tables that have already been imported to DataSelf's data warehouse.

Modify Structure window (Ctrl-M)

Navigation: Right-click on a table name in the Browse Table window, click Modify Structure.

Delete

Navigation: Right-click on a table name in the Browse Table window, click Delete.

Delete the imported table (the table in the DS data warehouse).

Reindex (CTRL-O)

Re-index table. A subset of the complete Refresh process.

Refresh (CTRL-R)

Navigation: Right-click on a table name in the Browse Table window, click 'Refresh.

Refresh the table currently selected in the Browse Table window. A refresh updates the table in the data warehouse from the source data according to the import mapping specified in the Import Table Wizard.

Recalculate (CTRL-C)

Recalculate formulas. A subset of the complete Refresh process.

Modify

May no longer be supported.

ETL Menu Bar (Menu Items)

Tools menu (drop-down). This example shows the sub-menu for Back up.

Tools Menu

SQL Server Connection

There is one data warehouse database per ETL project. This menu items opens the SQL Server Connection window which manages the connection to that data warehouse database.

ETL Toolbar Menu (Icons)

Most of the icons start the various ETL wizards.

View ETL Log (ALT-E)

See also View ETL Log.

ETL Settings and Configuration

ETL logging, log file settings

ETL Logic ( Logic, Functions and Operators )

NULL_Values - Ceiling, Round

ETL Refresh

dsrefresh.exe