• All Files

Access

Access is a database management system (DBMS) from Microsoft. This is an easy-to-use tool for creating business applications that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

 

Access connector by IConduct (supported via the Excel Provider) is designated for importing Microsoft Access files.

 

To configure the Access connector, follow the instructions below:

  1. In the Admin Navigation tree, select Connections and click New.

Connections Section in the Admin Navigation Tree

  1. Scroll down to the Data Files section and select the Access item from the list.

Connector Selection Page

  1. In the Excel Provider work area, fill in the following fields and click Save.

Connection Work Area

Fields Description
Connection*

The new connection name. Enter a connection alias here.
Is Active

Toggles connector’s activity at interface execution. Enable the checkbox to activate the connection for execution.
Cloud Agent*

The LAN you are working with. Select "IConduct" for cloud systems and your corporate agent for internal systems.
Implementation Type*

Defines the implementation type. Select from the drop-down list:

  • Default. IConduct scheduler works on the cloud agent set in the Cloud Agent field.
  • Java. IConduct scheduler works by sending requests to a Java agent.
Is Source

This connection entity is available as a data source for Import (writing to Schema). Enable the checkbox to ensure data import.
Is Target

This connection entity is available as a data target that receives data from schema to current data container. Enable the checkbox to ensure data export.
Timeout

The length of time (in milliseconds) the IConduct platform waits for a response from the connection provider before returning a timeout error. Set the time value to stop the system from connection attempts.

SQL
The box is intended for entering a query. You can test the defined query by clicking Test Query once the connection is saved. It’s recommended to test the query after the connection testing.
DateTime Format
Allows defining the date and time formats appropriate for the connection. For detailed date and time formatting operations please refer to this page.
Recommend Format: yyyy-MM-dd HH:mm:ss
Connection String*

A string that specifies information about a data source and the means of connecting to it. Specify the name and file type in the Connection String field. The connection string definition relates to the query type at the Import Step. Refer to this page for more information about connection strings.

Access connection string sample:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\iconduct\myAccessFile.accdb;Persist Security Info=False;

Username* Enter your username for authorization.
Password Enter your password for authorization.
Domain Enter your domain name (optional).

 

* -mandatory fields.

 

Once the connection is saved, you can test if it is successful. Click Test Connection in the toolbar. If the created connection works, you will receive a success message. 

Testing the Connection