Overview
Configuration is provided for establishing connections with Sisense via its REST API v1.0. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from the service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this task, we will show you step-by-step how to create a connection to a Sisense REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop down menu Configuration select Sisense.
Step 3. For successful authentication you need to replace [instance] inside Server address with actual instance and provide valid user's Name and Password
Step 3: After setting up the authentication parameters, test your connection by clicking Test connection button.
Step 1. Open the right side panel and drag and drop REST Source component. Double click on it and select Rest Sisense connection, select from available Sisense resources listed in second drop-down menu (Category) and click OK
Step 2. Check resource metadata by selecting Columns
Step 3. If necessary, you can configure the Error Output
Step 4. Connect REST Source component to desired destination component and edit mapping.
Step 1. Drag and drop REST Destination component from the SSIS Toolbox. Double click on it and select Rest Sisense connection, select from available Sisense resources listed in third drop-down menu (User) , select from available Action listed in second drop-down menu (Create).
Step 2. Connect desired source component to newly created REST Destination component and map columns.
Step 3. If necessary, you can configure the Error Output.
Configuration
Base URL address: https://[instance]/api/v1.
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- Name:
- Password:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users.The action has the following user-defined parameters:
- userName: Username to filter by
- email: Email to filter by
- firstName: First name to filter by
- lastName: Last name to filter by
- roleId: Role ID to filter by
- groupId: Group ID to filter by
- active: User state to filter by - "true" for active users, "false" for inactive users
- origin: User origin to filter by - "ad" for active directory or "sisense"
- ids: Array of user IDs to get, separated by a comma (,) and without spaces
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- expand: List of fields that should be expanded (substitutes their IDs with actual objects). May be nested using the "resource.subResource" format
- [Create] action
-
Endpoint URL address:
/users.
- [Update] action
-
Endpoint URL address:
/users/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/users/{{=item['_id']}}.
The resource includes the fields from the User template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.The action has the following user-defined parameters:
- name: Group name to filter by
- mail: Group email to filter by
- roleId: Group role ID to filter by
- origin: Group origin to filter by ("ad" or "sisense")
- ids: Group IDs to filter by, separated by a comma (,) and without spaces
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- expand: List of fields that should be expanded (substitutes their IDs with actual objects). May be nested using the "resource.subResource" format
- [Create] action
-
Endpoint URL address:
/groups.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item['_id']}}.
The resource includes the fields from the Group template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/roles.The action has the following user-defined parameters:
- includeManifest: Includes the role's manifest (list of permissions showing what's enabled/disabled).
- includeBaseRolesName: Includes the role's base role name
- compiledRoles: Select True
- envelop:
- [Create] action
-
Endpoint URL address:
/roles.
- [Delete] action
-
Endpoint URL address:
/roles/{{=item['_id']}}.
The resource includes the fields from the Role template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/dashboards.The action has the following user-defined parameters:
- name: Name to filter by
- parentFolder: Parent folder ID to filter by
- datasourceTitle: Data source name to filter by
- datasourceAddress: Data source address to filter by
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- expand: List of fields that should be expanded (substitutes their IDs with actual objects). May be nested using the "resource.subResource" format
- [Read all] action
-
Endpoint URL address:
/dashboards/admin.
- [Create] action
-
Endpoint URL address:
/dashboards.
- [Update] action
-
Endpoint URL address:
/dashboards/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/dashboards/{{=item['_id']}}.
The resource includes the fields from the Dashboard template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/dashboards/{{=parameters.dashboardId}}/shares.The action has the following user-defined parameters:
- dashboardId: Required. The ID of the dashboard who's shares to get
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- expand: List of fields that should be expanded (substitutes their IDs with actual objects). May be nested using the "resource.subResource" format
The resource includes the fields from the Share template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/dashboards/{{=parameters.dashboardId}}/widgets.The action has the following user-defined parameters:
- dashboardId: Required. The ID of the dashboard who's shares to get
- title: Widget title to filter by
- type: Widget type to filter by
- subtype: Widget sub-type to filter by
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- [Create] action
-
Endpoint URL address:
/dashboards/{{=item.dashboardid}}/widgets.
- [Update] action
-
Endpoint URL address:
/dashboards/{{=item.dashboardid}}/widgets/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/dashboards/{{=item.dashboardid}}/widgets/{{=item['_id']}}.
The resource includes the fields from the Widget template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/alerts.The action has the following user-defined parameters:
- ids: Array of alert IDs to get separated by a comma (,) and without spaces
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- expand: List of fields that should be expanded (substitures their IDs with actual objects). May be nested using the resource.subResource format
- [Create] action
-
Endpoint URL address:
/alerts.
- [Update] action
-
Endpoint URL address:
/alerts/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/alerts/{{=item['_id']}}.
The resource includes the fields from the Alert template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/connection.The action has the following user-defined parameters:
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- [Read recent] action
-
Endpoint URL address:
/connection/recent.
- [Create] action
-
Endpoint URL address:
/connection.
- [Update] action
-
Endpoint URL address:
/connection/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/connection/{{=item['_id']}}.
The resource includes the fields from the Connection template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasets/{{=parameters.datasetId}}/tables.The action has the following user-defined parameters:
- datasetId: Required. The ID of the dataset
- [Create] action
-
Endpoint URL address:
/datasets/{{=parameters.datasetId}}/tables.The action has the following user-defined parameters:
- datasetId: Required. The ID of the dataset
- [Delete] action
-
Endpoint URL address:
/datasets/{{=parameters.datasetId}}/tables.The action has the following user-defined parameters:
- datasetId: Required. The ID of the dataset
The resource includes the fields from the DatasetTable template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasets.The action has the following user-defined parameters:
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- type: Filters dataset by type
- [Create] action
-
Endpoint URL address:
/datasets.
- [Update] action
-
Endpoint URL address:
/datasets/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/datasets/{{=item['_id']}}.
The resource includes the fields from the Dataset template.
Based on resource template Base.
- [Read folders] action (alias: "Get folders")
-
Endpoint URL address:
/folders.The action has the following user-defined parameters:
- name: Name to filter by
- structure: Structure type of the folders
- ids: Array of folder IDs to get, separated by a comma (,) and without spaces
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- expand: List of fields that should be expanded (substitures their IDs with actual objects). May be nested using the resource.subResource format
- [Read subtree] action (alias: "Get folder subtree")
-
Endpoint URL address:
/folders/{{=parameters.id}}/subtree.The action has the following user-defined parameters:
- id: Required. The ID of the folder to get
- structure: Structure type of the folders
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- expand: List of fields that should be expanded (substitures their IDs with actual objects). May be nested using the resource.subResource format
- [Read ancestors] action (alias: "Get folder ancestors")
-
Endpoint URL address:
/folders/{{=parameters.id}}/ancestors.The action has the following user-defined parameters:
- id: Required. The ID of the folder to get
- structure: Structure type of the folders
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- expand: List of fields that should be expanded (substitures their IDs with actual objects). May be nested using the resource.subResource format
- [Read navver] action (alias: "Get all data for navver")
-
Endpoint URL address:
/navver.
- [Create] action
-
Endpoint URL address:
/folders.
- [Update] action
-
Endpoint URL address:
/folders/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/folders/{{=item['_id']}}.
The resource includes the fields from the Folder template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/ldap_domains.The action has the following user-defined parameters:
- enabled: Filter LDAP domains according to their status enabled or disabled
- name: name to filter the LDAP domains returned by
- ids: Array of LDAP domains IDs to get, separated by a comma (,) and without spaces
- fields: Whitelist of fields to return for each document. Can also define which fields to exclude by prefixing field names with "-"
- sort: Field by which the results should be sorted. Ascending by default, descending if prefixed by "-"
- skip: Number of results to skip from the start of the data set. To be used with the "limit" parameter for paging
- limit: How many results should be returned. To be used with the "skip" parameter for paging
- expand: List of fields that should be expanded (substitures their IDs with actual objects). May be nested using the resource.subResource format
- [Create] action
-
Endpoint URL address:
/ldap_domains.
- [Update] action
-
Endpoint URL address:
/ldap_domains/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/ldap_domains/bulk.The action has the following user-defined parameters:
- ids: Required. Array of LDAP domain IDs to delete, separated by a comma (,) and without spaces
The resource includes the fields from the LDAPDomain template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/authentication/server_access.
The result is extracted from:{{={ trustedServers: response } }}.
- [Create] action
-
Endpoint URL address:
/authentication/server_access.
- [Update] action
-
Endpoint URL address:
/authentication/server_access/{{=item['_id']}}.
- [Delete] action
-
Endpoint URL address:
/authentication/server_access/{{=item['_id']}}.
The resource includes the fields from the TrustedServer template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/fields/search.
The action uses POST method.The action has the following user-defined parameters:
- datasource: Required. Full name of the datasource
- search: Required. Example value: { "term": "string", "offset": 0, "count": 0, "ignoretypes": "string" }
The following request parameters will be automatically processed:
-
application/json:
{{=parameters.search}}
The resource includes the fields from the Datasource template.
Based on resource template Base.
- [Read elasticubes] action (alias: "Get elasticubes")
-
Endpoint URL address:
/elasticubes/getElasticubes.
- [Read nextElasticubes] action (alias: "Get next elasticubes")
-
Endpoint URL address:
/elasticubes/servers/next/{{=parameters.address}}.The action has the following user-defined parameters:
- address: Required. The Elasticube Server address
- [Update] action
-
Endpoint URL address:
/elasticubes/{{=item['server']}}/{{=item['title']}}/updateCube.
The action uses POST method.
The resource includes the fields from the Elasticube template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/sets.
- [Create] action
-
Endpoint URL address:
/elasticubes/sets.
- [Update] action
-
Endpoint URL address:
/elasticubes/sets/{{=item['titleAsId']}}.
- [Delete] action
-
Endpoint URL address:
/elasticubes/sets/{{=item['titleAsId']}}.
The resource includes the fields from the ElasticubeSet template.
Based on resource template Base.
- [Read servers] action (alias: "Get next servers")
-
Endpoint URL address:
/elasticubes/servers/next.The action has the following user-defined parameters:
- q: Term
- offset: Offset
- count: Count
- direction: Direction
- [Read serversStatus] action (alias: "Get next servers with status")
-
Endpoint URL address:
/elasticubes/servers/next/status.The action has the following user-defined parameters:
- q: Term
- offset: Offset
- count: Count
- direction: Direction
The resource includes the fields from the ElasticubesServers template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/live/{{=parameters.oid}}/permissions.The action has the following user-defined parameters:
- oid: Required. The oid of the live elasticube
- [Update] action
-
Endpoint URL address:
/elasticubes/live/{{=item['elasticubeOid']}}/permissions.
The resource includes the fields from the ElasticubePermission template.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/elasticubes/cubeShares.
The resource includes the fields from the ElasticubeShare template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/{{=parameters.server}}/{{=parameters.title}}/datasecurity.The action has the following user-defined parameters:
- server: Required. The elasticube's server address
- title: Required. The live elasticube’s title
- [Create] action
-
Endpoint URL address:
/elasticubes/{{=item['server']}}/{{=item['elasticubeTitle']}}/datasecurity.
- [Delete] action
-
Endpoint URL address:
/elasticubes/{{=item['server']}}/datasecurity/{{=item['_id']}}.
The resource includes the fields from the ElasticubeDataSecurity template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/{{=parameters.address}}/{{=parameters.cubeId}}/{{=parameters.tableName}}/relations.
The result is extracted from:{{=response.relations}}.The action has the following user-defined parameters:
- address: Required. The Elasticube Server address
- cubeId: Required. Cube Id or title
- tableName: Required. Table name
- [Create] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/relations.
- [Update] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/relations.
- [Delete] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/relations.
The resource includes the fields from the TableRelation template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/{{=parameters.address}}/{{=parameters.cubeId}}/{{=parameters.tableName}}/custom_fields.The action has the following user-defined parameters:
- address: Required. The Elasticube Server address
- cubeId: Required. Cube Id or title
- tableName: Required. Table name
- [Create] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/custom_fields.
- [Update] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/custom_fields/{{=item['fieldName']}}.
- [Delete] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/{{=item['tableName']}}/custom_fields/{{=item['fieldName']}}.
- address
Template: ShortText.
- cubeId
Template: ShortText.
- tableName
Template: ShortText.
- fieldName
Template: ShortText.
- fields
Template: JSONObject.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/{{=parameters.address}}/{{=parameters.cubeId}}/custom_tables.The action has the following user-defined parameters:
- address: Required. The Elasticube Server address
- cubeId: Required. Cube Id or title
- [Create] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/custom_tables.
- [Update] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/custom_tables/{{=item['tableNameAsId']}}.
- [Delete] action
-
Endpoint URL address:
/elasticubes/{{=item['address']}}/{{=item['cubeId']}}/custom_tables/{{=item['tableNameAsId']}}.
- address
Template: ShortText.
- cubeId
Template: ShortText.
- tableNameAsId
-
Documentation: Use for "Update" or "Delete" Custom tables..
- tableName
Template: ShortText.
- queryString
Template: LongText.
- tables
Template: JSONObject.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/live_connectors.
The resource includes the fields from the LiveConnector template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/elasticubes/live/{{=parameters.elasticubeOid}}/relations/{{=parameters.oid}}.
The result is extracted from:{{=[response]}}.The action has the following user-defined parameters:
- elasticubeOid: Required. The oid of the elasticube.
- oid: Required. The oid of the relation.
- [Create] action
-
Endpoint URL address:
/elasticubes/live/{{=item['elasticubeOid']}}/relations.
- [Update] action
-
Endpoint URL address:
/elasticubes/live/{{=item['elasticubeOid']}}/relations/{{=item['oid']}}.
- [Delete] action
-
Endpoint URL address:
/elasticubes/live/{{=item['elasticubeOid']}}/relations/{{=item['oid']}}.
The resource includes the fields from the ElasticubeRelation template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/plugins.
The result is extracted from:{{=response.plugins}}.The action has the following user-defined parameters:
- orderby: Filter by provided field
- desc: Order by descending/ascending
- search: Filter according to provided string
- skip: Number of results to skip from the start of the data set. skip is to be used with the limit parameter for paging
- limit: How many results should be returned. limit is to be used with the skip parameter for paging
- [Update] action
-
Endpoint URL address:
/plugins.
The resource includes the fields from the Plugin template.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/reporting.
The resource includes the fields from the EmailReport template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/settings/sso.
The result is extracted from:{{=[response]}}.
- [Create] action
-
Endpoint URL address:
/settings/sso.
The resource includes the fields from the SSOSettings template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/settings/pulse.
The result is extracted from:{{=[response]}}.
- [Create] action
-
Endpoint URL address:
/settings/pulse.
- [Update] action
-
Endpoint URL address:
/settings/pulse.
The resource includes the fields from the PulseSettings template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/settings/system.
The result is extracted from:{{=[response]}}.
- [Create] action
-
Endpoint URL address:
/settings/system.
The resource includes the fields from the SystemSettings template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/settings/email_server.
The result is extracted from:{{=[response]}}.
- [Create] action
-
Endpoint URL address:
/settings/email_server.
- [Update] action
-
Endpoint URL address:
/settings/email_server.
The resource includes the fields from the EmailServerSettings template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/settings/globalization.
The result is extracted from:{{=[response]}}.
- [Create] action
-
Endpoint URL address:
/settings/globalization.
- [Update] action
-
Endpoint URL address:
/settings/globalization.
The action uses PUT method.
The resource includes the fields from the GlobalizationSettings template.
- [Read] action
-
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Update] action
-
The action uses PATCH method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- JSONObject
Data type: DT_WSTR ( length 4000 )
- Integer
Data type: DT_I4
- Bool
Data type: DT_BOOL
- Date
Data type: DT_DBDATE
- DateTime
Data type: DT_DBTIMESTAMP
- Number
Data type: DT_R8
- File
Data type: DT_IMAGE
- User
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, email, userName, firstName, lastName, roleId, groups, adgroups, activeDirectory, principalName, objectSid, uSNChanged, dn, preferences, uiSettings, created, lastLogin, lastUpdated, pendingExpiration.
-
Uses template:
- Group
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, name, language, mail, ad, roleId, defaultRole, objectSid, uSNChanged, dn, created, lastUpdated.
-
Uses template:
- Role
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, name, displayName, parent, desc.
-
Uses template:
- Dashboard
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, title, desc, oid, source, parentFolder, type, shares, style, owner, userId, created, lastUpdated, datasource, filters, instanceType, layout, previewLayout, defaultFilters, widgets.
-
Uses template:
- Layout
Field components:
-
Uses template:
ShortText. - Contains the following components: type, columns.
-
Uses template:
- Filter
Field components:
- Contains the following components: jaql.
- Datasource
Field components:
-
Uses template:
ShortText. - Contains the following components: title, id, address, database, fullName.
-
Uses template:
- Share
Field components:
-
Uses template:
ShortText. - Contains the following components: shareId, type, rule, subscribe, permission, partyId.
-
Uses template:
- Widget
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, title, oid, datasource, type, subtype, dashboardid, owner, userId, instanceType, lastUpdated, metadata, shares.
-
Uses template:
- Alert
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, name, message, enabled, script, parties, disabledUsers, category, type, owner, context, action.
-
Uses template:
- Connection
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, owner, provider, timeout, refreshRate, timezone, schema, parameters.
-
Uses template:
- DatasetTable
Template: Table. Field components:
-
Uses template:
ShortText. - Contains the following components: vTag, lastUpdated, oid, type, hidden.
-
Uses template:
- TupleTransformation
Field components:
-
Uses template:
ShortText. - Contains the following components: type, arguments.
-
Uses template:
- ModelingTransformation
Field components:
-
Uses template:
ShortText. - Contains the following components: type, arguments.
-
Uses template:
- Column
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, type, size, scale, precision, lastUpdated, oid.
-
Uses template:
- Table
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, id, name, columns, tuple-transformations.
-
Uses template:
- Dataset
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, owner, elasticube, name, fullname, type, oid, connection, modeling-transformations, schema, schedule.
-
Uses template:
- Folder
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, name, oid, owner, type, userId, instanceType, created, lastUpdated, parentId.
-
Uses template:
- LDAPDomain
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, enabled, url, baseDN, username, name, syncUsn, syncActive, syncInterval, sslEnabled.
-
Uses template:
- TrustedServer
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, trustedServers, serverName, name.
-
Uses template:
- Datasource
Field components:
-
Uses template:
ShortText. - Contains the following components: id, column, table, dimtype, indexed, merged, tytle, type.
-
Uses template:
- ElasticubeSet
Field components:
-
Uses template:
ShortText. - Contains the following components: titleAsId, title, routingMode, failover, fullNames.
-
Uses template:
- ElasticubesServers
Field components:
-
Uses template:
ShortText. - Contains the following components: title, server, serverName, status, available, lastBuildUtc, sizeInMb, createdUtc, lastBuildStatus.
-
Uses template:
- ElasticubePermission
Field components:
-
Uses template:
ShortText. - Contains the following components: partyId, elasticubeOid, type, permission.
-
Uses template:
- ElasticubeShare
Field components:
-
Uses template:
ShortText. - Contains the following components: server, elasticube, shares.
-
Uses template:
- ElasticubeDataSecurity
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, elasticubeTitle, dataSourceId, allMembers, members, shares, datatype, table, column, cubeId, live, fullName, server.
-
Uses template:
- Elasticube
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, id, creator, datasets, lastBuildTime, lastUpdated, modeling-transformations, oid, relationType, server, shares, title, type, revision, schedule, fiscal.
-
Uses template:
- TableRelation
Field components:
-
Uses template:
ShortText. - Contains the following components: address, cubeId, tableName, sourceField, targetField, targetTable.
-
Uses template:
- LiveConnector
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, category, isLiveSupported, isWebECMSupported.
-
Uses template:
- ElasticubeRelation
Field components:
-
Uses template:
ShortText. - Contains the following components: elasticube, elasticubeOid, oid, columns, lastUpdated.
-
Uses template:
- Plugin
Field components:
-
Uses template:
ShortText. - Contains the following components: name, version, lastUpdate, isEnabled, folderName.
-
Uses template:
- EmailReport
Field components:
-
Uses template:
ShortText. - Contains the following components: assetId, assetType, recipients, preferences.
-
Uses template:
- SSOSettings
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, name, enabled, ssoType, loginUrl, logoutUrl, sharedSecret, loginUrlSaml, logoutUrlSaml, idPCert, lowSecurityJwtSso, syncGroupsFromSamlToken.
-
Uses template:
- PulseSettings
Field components:
-
Uses template:
ShortText. - Contains the following components: name, script.
-
Uses template:
- SystemSettings
Field components:
-
Uses template:
ShortText. - Contains the following components: _id, alias, firstday, fiscal, availableLanguagesList, dashboardAdministration, narration, pulse, usage, email, webServer, language.
-
Uses template:
- EmailServerSettings
Field components:
-
Uses template:
Bool. - Contains the following components: enable, host, port, secure, ignoreTLS, requireTLS, connectionTimeout, greetingTimeout, socketTimeout, user, pass, logger, debug.
-
Uses template:
- GlobalizationSettings
Field components:
-
Uses template:
Bool. - Contains the following components: language, localization.
-
Uses template:
Knowledge Base
What's New
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.