Difference between revisions of "Creating a DSN to a data warehouse"
Jump to navigation
Jump to search
(Created page with "== Overview == 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 ware...") |
|||
| Line 1: | Line 1: | ||
== Overview == | == Overview == | ||
[[File:ODBCDataSources.png|200px|thumb|right|ODBC Data Sources]] | |||
[[File:ODBCDataSourceAccess1.png|200px|thumb|right|ODBC Drivers]] | |||
[[File:ODBCDataSourceAccess2.png|200px|thumb|right|ODBC Microsoft Access DSN]] | |||
The [[Data Warehouses]] within ODBClink are used a storage mechanism to store the data form your accounting package. | The [[Data Warehouses]] within ODBClink are used a storage mechanism to store the data form your accounting package. | ||
| Line 13: | Line 17: | ||
# Click '''OK''' to close the dialogue; | # Click '''OK''' to close the dialogue; | ||
# Close the ODBC Data Source Dialogue. | # Close the ODBC Data Source Dialogue. | ||
[[Category:How To Guides]] | |||
Revision as of 00:30, 9 July 2014
Overview
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.
- 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;
- Select the System DSN tab;
- Click on the Add... button;
- Select the relevant driver, typically Microsoft Access Driver (*.mdb) and click Finish;
- Enter a Data Source Name for your DSN;
- Click the Select button and browse to the data warehouse (typically located in c:\ODBClink...\System\);
- Click OK to close the dialogue;
- Close the ODBC Data Source Dialogue.