Intellicus Enterprise Reporting and Business Insights 19.0

Creating Connections

0 views June 28, 2020 0

Creating connection to R Data Science Engine requires a prerequisite file system-based connection. This connection’s file location helps as a shared location to exchange data between Intellicus and R.

The first step will be to create a file system connection. The second step will be to create connection to Data Science Engine and providing the file connection location created in step 1.

Creating connection to File System

To create this, please follow the below steps.

  1. Login to Intellicus – Navigate – Administration – Configure – Databases Tab
  2. Click on Add
  3. The page will display the following options

file system connection
Figure 1: Adding a file system-based connection
Connection Properties

Item Values Comments
Connection Name Provide a name as per your desire This connection is used as a file-system to exchange data, and this name will be required while connecting to Data Science Engine
Provider Select from the drop down Intellicus stores the temporary processing data as a file, hence you need to select Files/Stream
Driver Type Select from the drop down You need to select network path to specify the location to save your file
LOCATION Provide the location where the file will be saved This location will be used by the Data Science Engine and Intellicus to exchange data while processing the data in Data Science step.

Make sure you uncheck read only in the settings of this connection as it will be accessed by both Intellicus and Data Science Engine to exchange data.

Note: To get more details to create a file system connection, please refer “WorkingwithDatabaseConnections.pdf”

Once you have given the required details, you can test your connection if it has been successfully created, Save it once you get the message ‘Connection Test Succeeded.’ Cancel if you want to start afresh.

You can Delete a connection once you have saved it or Refresh Schema to let Intellicus refresh the data from the connected database.

Creating connection to Data Science Engine

To create this, please follow the below steps –

  1. Login to Intellicus – Navigate – Administration – Configure – Databases tab
  2. Click on Add
  3. The page will display the following options

connection to Data Science Engine
Figure 2: Creating a connection to Data Science Engine

Note: To create a connection to Data Science Engine, you must have a Data Science Engine running parallel on this network.

Data Science Engine Connection Properties

Item Values Comments
Connection Name Rserver This property will get affected once you choose Data Science Engine provider from the provider drop down. By default, the connection name will remain Rserver as Intellicus is providing connection to R server in this version. The name will be used as a reference at many places hence it is set by default

Note- you need to select ‘Provider’ to be able to enter this field

Provider Select DATA SCIENCE ENGINE from the drop down Since we need to create a connection to Data Science engine, run to the bottom of the list and select DATA SCIENCE ENGINE
Platform Select from the drop down Specify the Data Science engine you need to connect. For now, RServe is available
Server Type yourself Provide the server IP address where your Data Science engine is running
Port Type yourself Provide the port details on which your Data Science engine is running
Dump Connection Name Type yourself Here you need to type the name of the file-based system connection you formed in the first step
Rows To Dump While Verification Type yourself Whatever number you enter here, only those many rows from your raw data will be dumped to verify the correctness of the script. By default, the filed remains blank.
Connection String Autogenerated Connection string to connect to the Data Science engine
Mask Connection String Check/Uncheck If checked connection string is masked
Charset Encoding Select from list Leave it blank
Pool Settings Initial Connections Type yourself This feature helps you to define how many initial connections Intellicus will form to the engine so as once you start using it, there are no delays and your process carries out smoothly.

Default: 5

Incremental Size Type yourself Once all the available connections are used, increment size helps to increase the number of connections and forms new connections as per the specified number.

Default: 5

Resubmit Time Type yourself If the connections were increased and in use, resubmit time checks the current number of connections in use. If the connection value goes down to initial connection value, the incremented connections are released

Default: 30 seconds

Max Connections Type yourself The value here specifies how many connections can be formed at max. Say your max connections are 30 and all are in use. If any more connection request is raised, it will go to a queue

Default: 30

Once you have given the required details, you can Test your connection if it has been successfully created, save it once you get the message ‘Connection Test Succeeded.’ Cancel if you want to start afresh.

You can Delete a connection once you have saved it or Refresh Schema to let Intellicus refresh the data from the connected source.