• All Files

MFG Pro

MFG/PRO is an enterprise resource planning (ERP) suite designed to help manufacturing companies streamline their operations. MFG/PRO includes an extensive set of solution components for manufacturing, distribution, and financial.

The MFG Pro connector by IConduct allows organizing a seamless data transfer between MFG databases and other company’s business applications. The connection is established via ODBC Provider.

 

To configure the MFG 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 MFG Pro item from the Database Servers section.

Connector Selection Page

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

Connection Details Area

Field 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 connection 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.

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 connection.

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. Refer to this page for more information about connection strings.

Example:

1. DSN=myDsn;Uid=myUsername;Pwd=;

where

DSN - Data Source Name - a string that has an associated data structure used to describe a connection to a data source.

Uid - Your username to MFG Pro database.

Pwd - Your password to MFG Pro database.

Prefix

A part of the MFG Pro database table name. If applicable, enter the table prefix here.

Username

Username in the MFG Pro database. The value is set in the Connection String and used here for impersonation to the system where the IConduct agent is running.

Password

Password to the MFG Pro database. The value is set in the Connection String and used here for impersonation to the system where the IConduct agent is running.

Domain

Company’s domain name.

 

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