ETL+ for MS Access
Installation Checklist
Connecting to Microsoft Access
If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.
Login to ETL+ (help here).
Adding a new Access file: On ETL page’s left panel, click
Add Source
->MS Access
.Maintaining an Access source: On ETL page’s left panel, right-click the Access source →
Properties
.On the
Microsoft Access
page:The
Alias
box will be automatically populated, but you can customize it.File Path
: Enter a local Access file or useBrowse
to find it.Supported Access formats: MDB, ACCDB.
If applicable, enter the
Password
.Click
Connect
.
You’ll get back to the ETL page and see tables under the selected Access source on the left panel.
Mapping and Loading Tables
To view tables available from an Access source on the left panel, right-click the Access source →
Refresh
.To map an Access table to the data warehouse,
double-click its name
on the left panel, or right-click on it →Add Table
.You’ll now see the table added/mapped to the center panel.
To preview its data, right-click the table on the center panel →
Preview
.To load its data to the data warehouse, right-click the table on the center panel →
Load Now
.Click the
Log
icon (top right) to view data load results. Log page help here.
Schedule the Data Load
On the ETL main page, click
Job
(top right icon on the center panel).Select a Job or create a new one to load your Access data on a schedule (help here) → on the right panel, be sure the Access tables to load have their boxes checked and in the desired load order.
To load them now, click the
Run Job
(play icon) on the left panel for the desired Refresh Batch.To schedule the data load:
Click
WTS Settings
-> enter the WTS parameters →Apply
.This step might require you to run ETL+ app as “Run as administrator” in Windows.
Click
Close
->Close
.
Testing
After ETL+ has loaded your Access files, this is to check if the data extraction process finished successfully and row count per extracted table matches with your Access tables.
Steps
Login to ETL+ (help here).
On the ETL main page, click the top-right
Log
icon. Log page help here.Scroll down on the log page and double-check that no table load failed, and the row count matches with the Access tables. Following is an example highlighting two tables and their loaded row count.