• All Files

MDF/Fox Pro

The information on this page relates to the new upgraded interface of the IConduct platform. To view information about the Classic version of the user interface, follow this link.

 

An MDF file attributes to the databases created using Microsoft SQL Server. FoxPro is a text-based procedurally oriented programming language and database management system (DBMS), and it is also an object-oriented programming language.

 

The MDF/Fox Pro connector by IConduct (supported via the Excel Provider) allows users to access mdf databases for data import.

 

To configure the MDF/Fox Pro connector, follow the instructions below:

 

  1. In the Main Menu, select Connections and press Create connection.

Accessing connections

  1. On the Connector Selection Page select the MDF/Fox Pro item from the Data Files section.

Connector Selection Page

  1. In the Excel Provider work area, fill in the following fields and press Create.

Connection Details Area

Fields Description

Connection*

A 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

Not used in this connector.

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.

Query

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

Not used in this connector.

Connection String*

A string that specifies information about a data source and the means of connecting to it. Specify the connection properties in the Connection String field. Refer to this page for more information about the FoxPro connection strings.

MDF/Fox Pro:Provider=vfpoledb;Data Source=d:\iconduct\MyDbContainer.dbc;Collating Sequence=machine;

Note: Data Source is the database container path.

Username

Used for impersonation to perform operations with the connector on behalf of the user other than the IConduct agent user. Enter the username here.

Password

Used for impersonation. Enter the user password here.

Domain

Used for impersonation. Enter the required company domain name here.

* - mandatory fields

 

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

Testing the Connection