Connecting to Access
This article shows you how to connect to Microsoft Access (MDB/ACCDB) database files.
2. Drag and drop an Access file
The easiest way to work with an Access file is to drag it from Windows Explorer and drop it directly onto the Dundas BI Explore window or the dashboard canvas.
This will automatically create a corresponding data connector in Dundas BI. Expand the data connector and drag a table to the canvas to see its data.
3. Connect to Access file
The following walkthrough shows you how to manually create a data connector for an Access file.
To begin, go to the main menu, click New, and then select Data Connector.
In the New Data Connector dialog, click inside the File Name box. Enter a name for your data connector.
Click the Data Provider dropdown and choose Access and DBF.
Click the Authentcation dropdown to choose an authentication method. For example, set it to Specified Windows credentials and enter your domain, username, and password on Windows.
Next, specify the Access file you want to connect to by using one of these options:
- Click Choose File and use the file selector to select the Access file.
- Or, use the UNC Path option to specify the full network path to the file. Example: \\server1\shared\MarketData.mdb
In typical cases, you can simply click Submit to complete the data connector and perform the initial discovery. But there are some advanced options which you can set as described in a later section.
To use the data connector, create a new dashboard and then go to Explore. Locate and expand your Access data connector. Drag a native structure (e.g., view or table) to the dashboard canvas to see its data.
The following options are available for the Access and DBF data provider.
- Extended Properties - Provider-specific connection information that cannot be described explicitly through standard properties.
- Locale Identifier - The locale ID (LCID) specifies the database's collating order, which is the character set that will be used to determine how values in the database are sorted.
- Authentication - The authentication method to use.
4.2. Jet OLEDB
- Database Password - Required to open a password-protected database.
- Registry Path - The path to the registry subkey to use for Jet database engine settings.
- Database Locking Mode - Specifies the mode used when locking the database to read or modify records.
- User ID - The user's ID (for user-level security).
- User Password - The user's password (for user-level security)
- System Database - Specifies the location of the Microsoft Jet workgroup information