• All Files

Data File Folder

Data File Folder is a container for your files. The Data File Folder connector allows uploading data in bulk from the folder files to the IConduct schema. The connector is supported by the OLE DB Provider. OLE DB (Object Linking and Embedding Database) is a low-level API designed by Microsoft to access different data sources in a uniform manner. Through OLE DB, the Data File Folder connection allows you to seamlessly manage files of any text extension.

 

To configure the Data File Folder 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 Data File Folder item from the list.

Connector Selection Page

  1. In the OLE DB File Folder Provider work area, fill in the following fields and click Save.

Connection Work 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

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.

DateTime Format

Not used in this connector.

Connection String*

The OLE DB provider connection string that includes the data source name, and other parameters needed to establish the initial connection. Fill it in complying with the following pattern:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\input;Extended Properties="Excel 12.0 Xml;HDR=YES";

For more information refer here.

File Pattern*

Enter the file pattern you are going to work with.

For example: *.xlsx, *csv, *txt

Sample File Name*

This field will be applied in query preview and create columns in mapping. Enter the file name pattern you are going to work with.

For example: priority_reverse.xlsx

Move to folder

The folder where the file will be stored.

For example: d:\finish

 

* - 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