• All Files

Priority over SQL Server

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.

 

Priority Software provides flexible, end-to-end business management solutions for organizations of all sizes in a wide range of industries. Priority’s ERP functionality covers all the core elements of traditional ERP, with primary modules including finance, manufacturing, logistics, human resources, time and attendance, business intelligence, project management, CRM and customer service and support – offered as end-to-end product suites or individual modules.

 

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

 

The Priority over SQL Server Connector by IConduct allows handling the data flow to and from Priority ERP databases based on SQL Server.

 

To configure the Priority over SQL Server connector, follow the instructions below:

 

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

Accessing connections

  1. Scroll down to the ERP/Accounting section and select the Priority over Oracle item from the list.

Connector Selection Page

  1. In the Priority ERP 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

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.

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.

Recommended Format: yyyy-MM-dd HH:mm:ss

Server URL

The service end-point where the request is sent. Insert the URL to the SQL server here.

Username

Username for authentication to the SQL server.

Password

Password for authentication to the SQL server.

Connection String*

A string that specifies information about a data source and the means of connecting to it.

The connection string should match the following format:

Server=myServerAddress;Database=*;User Id=myUsername;Password=myPassword;

where:

  • Server - the name of an SQL Server instance. The value must be either the name of a server on the network, an IP address, or the name of an SQL Server Configuration Manager alias.
  • Database – the name of the SQL Server database for the connection listed in the Database List field. Important! Make sure to set Database=*.
  • UserID - A valid SQL Server login account. UID should not be specified when using Windows Authentication.
  • Password - The password for the SQL Server login account specified in the UID parameter.

Refer to this page for more information about connection strings.

Database List*

Specify the list of the databases to refer to, separated by semicolon.

 

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