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...") |
|||
(4 intermediate revisions by 2 users not shown) | |||
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 5: | Line 9: | ||
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. | 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'''; | # From the Menu within ODBClink, click on either the '''Click here to view 64-bit DSNs''' or the '''[[View 32-bit DSNs|Click here to view 32-bit DSNs]]'''; | ||
# Select the '''System DSN''' tab; | # Select the '''System DSN''' tab; | ||
# Click on the '''Add...''' button; | # Click on the '''Add...''' button; | ||
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. | ||
<br clear=all /> | |||
== Related Topics == | |||
* [[How To Guides]] | |||
[[Category:How To Guides]] |
Latest revision as of 20:59, 12 July 2017
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.