Sciforma

Sciforma is a cloud platform for portfolio and project management. An access to Sciforma data is wrapped by SDK written in Java programming language and packed into a set of the JAR files. Sciforma connector enables you to manage the data through the IConduct supported list of JAR files:

  • PSClient.jar
  • PSClient_en.jar
  • utilities.jar

 

To configure the Sciforma connector, follow the instructions below:

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

Connections Section in the Admin Navigation Tree

  1. On the Connector Selection page select theSciforma item from the ERP/Accounting section.

Connector Selection Page

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

Connection Work Area

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

Note: Select a Java Agent as a Cloud Agent for Sciforma.

Implementation Type

Defines the connection implementation type. Supported values:

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

Note: Select Java as an Implementation Type for Sciforma.

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.

Note: Timeout for Sciforma response is 1min.

SQL

SQL box is intended for entering an SQL query. The user can test the SQL 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: https://msdn.microsoft.com/enus/library/8kb3ddd4(v=vs.110).aspx

SQL Server Name

The name of the SQL server instance.

Database

The name of the database.

Username/Password

The credentials to access the Sciforma account.

 

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