Haystack Point History connector
Overview#
The Haystack Point History connector gathers analytics data which is then used in various analytics dashboards.
How the Haystack Point History connector works#
The Haystack Point History connector first extracts data for SkySpark endpoints and loads it into the analytics database. SkySpark is an analytics software platform which analyzes data from smart building systems.
Then, Sisense, a data analytics tool, fetches this data from the analytics database and consumes it to display analytics dashboards to users.
Note: The Haystack Point History connector performs incremental loading by retrieving only new records since the last stored timestamp. It also limits data extraction to the past two years.
How to use the Haystack Point History connector#
To use the Haystack Point History connector, pass an object with the parameters you require, from the schema table listed below. Also refer to the code sample listed below.
Haystack Point History Connector schema#
| Property | Type | Description | Required |
|---|---|---|---|
_orchcomp | String | Enter “J2_Sisense_HisPoint_Connector”. | Required |
_name | String | Enter a descriptive name for what the component does in the orchestrator. | Optional |
_sequenceno | Integer | Enter a number that defines the task’s order in the sequence of tasks to execute. | Required |
_actualparams | Object | Pass an object that contains formal parameters or alternative parameters you want to add as key-value pairs, such as “userType”: “<your-user-type>”. See below. | Optional |
_actualparams.project | String | Takes a project name as a string. | Required |
_actualparams.url | String | Takes a datasource URL as a string. | Required |
_actualparams.uname | String | Takes the Sisense account username as a string. | Required |
_actualparams.pwd | String | Takes the Sisense account password as a string. | Required |
Code example#
Refer to the code sample below.
… { "_orchcomp": "J2_Sisense_HisPoint_Connector", "_name": "Haystack Point History Connector", "_sequenceno": 1, "_actualparams": { "project": "project_name", "url": "<URL-to-your-datasource>", "uname": "johnDoe", "pwd": "secret" } }, …