Docube Query

Docube Query node is used to fetch data from Docube. It works similar to DB node. This node allows the user to take input data from Jiffy Docube application. Here user can write SQL queries to read data from CSV files available in Docube application.

Pre-condition:

Before using a Docube Query node in designing any task, the Docube configuration must be defined.

1.1 Defining Docube Query Configuration:

Do the following to define the Docube configuration:
1. Log in to Jiffy.
2. Navigate to Task Design -> Configurations -> Docube Configuration.
3. Click on the Add button to define the configuration.
   
   The following list box is displayed with two options:
   
   
   • Create New: Use this option to create a new Docube configuration.
     Do the following to add new configuration:
     • Click on the Create New button to display the display the Add Docube Configuration window.
       
       Specify the details for the following fields:
       • Configuration Name: Name to be provided for the configuration and the specified name is used in the Properties section of the node.
       • Protocol: Select the required protocol (HTTP or HTTPS) from this drop-down.
       • Server URL: Type the required server URL.
       • Port: Docube uses port 443.
     • Click on the Save button.
4. Copy Existing: Use this option to copy from the existing configurations that are defined earlier.
   • Click on the Copy Existing button to display the Copy Configuration window.
     
     
   • Type the details of the required configuration in the above Search fields.
   • Select the required configuration from the filtered list.
   • Click on the Copy button.

Note: All the defined Docube configurations are available in the Docube Configuration list box in the Properties tab of the Task Design screen for creating a task using a Docube Query Node.


Designing a Task Using a Docube Query Node:

1. Use an existing task or create a new task based on the requirement.
   Note: Refer Create A Task for more details on how to create a task and how to open an existing task.
2. Drag and drop the Docube Query node from the Objects -> Data Sources section and connect the nodes.
   
   
3. Click on the Docube Query node and specify the properties:
   
   Add the following details:
   • Name: Name of the node. A default name is displayed in this field, which the user can edit according to the task and the intent of using the node.
   • Description: A short note on the purpose of the node.
   • Mark run Failure on Node Fail: When the Mark run Failure on Node Fail field is ON, if the node execution fails then the complete task execution is marked as fail.
   • Run with User config?: This functionality is now deprecated.
   • Continue on no result?: When Continue on no result? field is ON, the task execution continues even when the Docube query returns no results. When Continue on no result? field is OFF,if the node fails, the execution will not continue to the next node.
   • Docube Configuration: Selects the Docube configuration to be used for accessing the Docube.
   • Query (give parameter in $[]): The Drill query used to get the required results from the Docube datasheets.
     For Example: select`Date_Posted`,`Value_Date`from`/BankReconciliation/InterCompanyTrans` Note: A proper SQL query needs to be written based on the type of Docube being used for the node to perform the task correctly.
   • Columns in result set (space separated): Names of the columns that are needed from the result set. Separate each column name with a space in between them. This is supported only for Select statements.
   • Iterate on this node’s output?: When this is turned ON, the task will iterate on the Docube Query node’s output.
4. Click on the Trail Runbutton.
5. Click on the book icon above the Docube Query node to display the Result of execution window of the Docube Query node.