Creating a DSN to a data warehouse

From ODBClink wiki
Jump to navigation Jump to search

Overview

ODBC Data Sources
ODBC Drivers
ODBC Microsoft Access DSN

The Data Warehouses within ODBClink are used a storage mechanism to store the data form your accounting package.

To manipulate the data within a data warehouse, it is preferable to use a DSN. Follow these instructions to create a DSN to your data warehouse.

  1. From the Menu within ODBClink, click on either the Click here to view 64-bit DSNs or the Click here to view 32-bit DSNs;
  2. Select the System DSN tab;
  3. Click on the Add... button;
  4. Select the relevant driver, typically Microsoft Access Driver (*.mdb) and click Finish;
  5. Enter a Data Source Name for your DSN;
  6. Click the Select button and browse to the data warehouse (typically located in c:\ODBClink...\System\);
  7. Click OK to close the dialogue;
  8. Close the ODBC Data Source Dialogue.


Related Topics