Cinchy Platform Documentation
Cinchy v5.6
Cinchy v5.6
  • Data Collaboration Overview
  • Release Notes
    • Release Notes
      • 5.0 Release Notes
      • 5.1 Release Notes
      • 5.2 Release Notes
      • 5.3 Release Notes
      • 5.4 Release Notes
      • 5.5 Release Notes
      • 5.6 Release Notes
  • Getting Help
  • Cinchy Glossary
  • Frequently Asked Questions
  • Deployment Guide
    • Deployment Installation Guides
      • Deployment Planning Overview and Checklist
        • Deployment Architecture Overview
          • Kubernetes Deployment Architecture
          • IIS Deployment Architecture
        • Deployment Prerequisites
          • Single Sign-On (SSO) Integration
            • Enabling TLS 1.2
            • Configuring ADFS
            • AD Group Integration
      • Kubernetes Deployment Installation
        • Disabling your Kubernetes Applications
        • Changing your File Storage Configuration
        • Configuring AWS IAM for Connections
        • Using Self-Signed SSL Certs (Kubernetes Deployments)
        • Deploying the CLI (Kubernetes)
      • IIS Deployment Platform Installation
    • Upgrade Guides
      • Upgrading Cinchy Versions
        • Cinchy Upgrade Utility
        • Kubernetes Upgrades
          • v5.1 (Kubernetes)
          • v5.2 (Kubernetes)
          • v5.3 (Kubernetes)
          • v5.4 (Kubernetes)
          • v5.5 (Kubernetes)
          • v5.6 (Kubernetes)
          • Upgrading AWS EKS Kubernetes Version
          • Updating the Kubernetes Image Registry
          • Upgrading AKS (Azure Kubernetes Service)
        • IIS Upgrades
          • v4.21 (IIS)
          • v4.x to v5.x (IIS)
          • v5.1 (IIS)
          • v5.2 (IIS)
          • v5.3 (IIS)
          • v5.4 (IIS)
          • v5.5 (IIS)
          • v5.6 (IIS)
      • Upgrading from v4 to v5
  • Guides for Using Cinchy
    • User Guides
      • Overview of the Data Browser
      • The Admin Panel
      • User Preferences
        • Personal Access Tokens
      • Table Features
      • Data Management
      • Queries
      • Version Management
        • Versioning Best Practices
      • Commentary
    • Builder Guides
      • Best Practices
      • Creating Tables
        • Attaching Files
        • Columns
        • Data Controls
          • Data Entitlements and Access Controls
          • Data Erasure
          • Data Compression
        • Formatting Rules
        • Indexing and Partitioning
        • Linking Data
        • Table and Column GUIDs
        • System Tables
      • Deleting Tables
        • Restoring Tables, Columns, and Rows
      • Saved Queries
      • CinchyDXD Utility
        • Building the Data Experience (CinchyDXD)
        • Packaging the Data Experience (CinchyDXD)
        • Installing the Data Experience (CinchyDXD)
        • Updating the Data Experience (CinchyDXD)
        • Repackaging the Data Experience (CinchyDXD)
        • Reinstalling the Data Experience (CinchyDXD)
      • Multi-Lingual Support
      • Integration Guides
    • Administrator Guide
    • Additional Guides
      • Monitoring and Logging on Kubernetes
        • Grafana
        • Opensearch Dashboards
          • Setting up Alerts
        • Monitoring via ArgoCD
      • Maintenance
      • System Properties
      • Enable Data At Rest Encryption
      • MDQE
      • Application Experiences
        • Network Map
          • Custom Node Results
          • Custom Results in the Network Map
        • Setting Up Experiences
  • API Guide
    • API Overview
      • API Authentication
      • API Saved Queries
      • ExecuteCQL
      • Webhook Ingestion
  • CQL
    • The Basics of CQL
      • CQL Examples
      • CQL Functions Master List
      • CQL Statements Overview
        • Cinchy DML Statements
        • Cinchy DDL Statements
      • Cinchy Supported Functions
        • Cinchy Functions
        • Cinchy System Values
        • Cinchy User Defined Functions
          • Table-Valued Functions
          • Scalar-Valued Functions
        • Conversion Functions
        • Date and Time Types and Functions
          • Return System Date and Time Values
          • Return Date and Time Parts
          • Return Date and Time Values From Their Parts
          • Return Date and Time Difference Values
          • Modify Date and Time Values
          • Validate Date and Time Values
        • Logical Functions
        • Mathematical Functions
        • String Functions
        • Geometry and Geography Data Type and Functions
          • OGC Methods on Geometry & Geography Instances
          • Extended Methods on Geometry & Geography Instances
        • Full Text Search Functions
        • Connections Functions
        • JSON Functions
  • Meta Forms
    • Introduction to Meta-Forms
    • Meta-Forms Deployment Installation Guide
      • Deploying Meta-Forms (Kubernetes)
      • Deploying Meta-Forms (IIS)
    • Forms Data Types
    • Meta-Forms Builders Guides
      • Creating a Dynamic Meta-Form (Using Tables)
      • Creating a Dynamic Meta-Form Example (Using Form Designer)
      • Adding Links to a Form
      • Rich Text Editing in Forms
  • Data Syncs
    • Getting Started with Data Syncs
    • Installation & Maintenance
      • Prerequisites
      • Installing Connections
      • Installing the Worker/Listener
      • Installing the CLI and the Maintenance CLI
    • Building Data Syncs
      • Types of Data Syncs
      • Common Design Patterns
      • Sync Behaviour
      • Columns and Mappings
        • Calculated Column Examples
      • Listener Configuration
      • Advanced Settings
        • Filters
        • Parameters
        • Auth Requests
        • Request Headers
        • Post Sync Scripts
        • Pagination
      • Batch Data Sync Example
      • Real-Time Sync Example
      • Scheduling a Data Sync
      • Connection Functions
    • CLI Commands List
    • Error Logging and Troubleshooting
    • Supported Data Sync Sources
      • Cinchy Event Broker/CDC
        • Cinchy Event Broker/CDC XML Config Example
      • Cinchy Table
        • Cinchy Table XML Config Example
      • Cinchy Query
        • Cinchy Query XML Config Example
      • Copper
      • DB2 (Query and Table)
      • Dynamics 2015
      • Dynamics
      • DynamoDB
      • File Based Sources
        • Binary File
        • Delimited File
        • Excel
        • Fixed Width File
        • Parquet
      • Kafka Topic
        • Kafka Topic Example Config
        • Apache AVRO Data Format
      • LDAP
      • MongoDB Collection
        • MongoDB Collection Source Example
      • MongoDB Collection (Cinchy Event Triggered)
      • MS SQL Server (Query and Table)
      • ODBC Query
      • Oracle (Query and Table)
      • Polling Event
        • Polling Event Example Config
      • REST API
      • REST API (Cinchy Event Triggered)
      • SAP SuccessFactors
      • Salesforce Object (Bulk API)
      • Salesforce Platform Event
      • Salesforce Push Topic
      • Snowflake
        • Snowflake Source Example Config
      • SOAP 1.2 Web Service
    • Supported Data Sync Destinations
      • Cinchy Table
      • DB2 Table
      • Dynamics
      • Kafka Topic
      • MongoDB Collection
      • MS SQL Server Table
      • Oracle Table
      • REST API
      • Salesforce Object
      • Snowflake Table
      • SOAP 1.2 Web Service
    • Supported Real-Time Sync Stream Sources
      • Cinchy Event Broker/CDC
      • Data Polling
      • Kafka Topic
      • MongoDB
      • Salesforce Push Topic
      • Salesforce Platform Event
  • Other Resources
    • Angular SDK
    • JavaScript SQK
Powered by GitBook
On this page
  • 1. Excel
  • 1.1 Prerequisites
  • 1.2 Using Basic Auth
  • 1.3 Using a Personal Access Token
  • 1.4 Using a Bearer Token
  • 2. Power BI
  • 2.1 Prerequisites
  • 2.2 Using Basic Auth
  • 2.3 Using a Personal Access Token
  • 2.4 Using a Bearer Token
  • 3. Tableau
  • 3.1 Prerequisites
  • 3.2 Connecting From Tableau

Was this helpful?

Export as PDF
  1. Guides for Using Cinchy
  2. Builder Guides

Integration Guides

This page contains various Integration Guides

PreviousMulti-Lingual SupportNextAdministrator Guide

Last updated 2 years ago

Was this helpful?

1. Excel

There are various methods you can use to establish a connection between Cinchy and Microsoft Excel, such as using Basic Auth, Personal Access Tokens, or Bearer Tokens.

Review each section below for further details.

1.1 Prerequisites

Excel connects to queries within Cinchy, therefore prior to using any of the connection methods below you will need to create one that represents your dataset. Once created, you will need to copy down the , located as a green button on the right-hand side of the Execute Query screen.

The structure of the URL endpoint is <your Cinchy instance URL>/API/<the name of your query>. You might optionally have querystring parameters at the end as well.

For example: http://your.cinchy.instance.domain/API/YourQueryDomain/API Test

Note that for Basic Authentication with a result format of CSV we will use a slightly different URL endpoint. For Basic Auth: /API/ becomes /BasicAuthAPI/ For CSV results you will add the querystring parameter of ResultFormat=CSV

Our example URL for an basic auth using CSV results would then become: http://your.cinchy.instance.domain/BasicAuthAPI/YourQueryDomain/API Test?ResultFormat=CSV

1.2 Using Basic Auth

  1. Launch Excel and navigate to Data > Get Data > From Other Sources > Blank Query (Image 1).

  1. In the expression box that appears, enter the below text to add in your query as your data source (Image 2):

=Csv.Document(Web.Contents("API ENDPOINT URL"))

Example:

=Csv.Document(Web.Contents("http://your.cinchy.instance.domain/BasicAuthAPI/YourQueryDomain/API Test?ResultFormat=CSV"))

  1. Once you've entered that text either click the check mark to the left of the input box or click away and it will automatically attempt to run the expression.

  2. The data may return in HTML format initially and not be what you're expecting. To correct this:

    1. Click the Data Source Settings.

    2. Select Basic and enter the credentials for a Cinchy User Account that has access to run this query.

    3. Click OK.

    4. Within the Edit Permissions dialogue, click OK.

    5. Within the Data Source Settings dialogue, click Close.

    6. Click Refresh Preview.

    7. Click Close & Load and your dataset will be displayed in the Excel worksheet.

1.3 Using a Personal Access Token

  1. Launch Excel and navigate to Data > From Web.

  2. Click Advanced and input the following values (Image 3):

    1. HTTP Request Header Parameters:

      1. In the first text box input Authorization

      2. In the second text box type Bearer + your PAT. For example: "Bearer BGFHFHOJDF76DFDFD777"

  1. Click OK.

  2. Click Load to use the query data in Excel (Image 4).

1.4 Using a Bearer Token

  1. Launch Excel and navigate to Data > From Web.

  2. Click Advanced and input the following values (Image 5):

    1. HTTP Request Header Parameters:

      1. In the first text box input Authorization

      2. In the second text box type Bearer + your token. For example: "Bearer eyUzI1NiIsImtpZCI6IkE4M0UwQTFEQTY1MzE0NkZENUQxOTFDMzRDNTQ0RDJDODYyMzMzMzkiLCJ0eXAiO"

  1. Click OK.

  2. Click Load to use the query data in Excel (Image 6).

2. Power BI

There are various methods you can use to establish a connection between Cinchy and Power BI, such as using Basic Auth, Personal Access Tokens, or Bearer Tokens.

Review each section below for further details.

2.1 Prerequisites

The structure of the URL endpoint is <your Cinchy instance URL>/API/<the name of your query>. You might optionally have querystring parameters at the end as well.

For example: http://your.cinchy.instance.domain/API/YourQueryDomain/API Test

Note that for Basic Authentication with a result format of CSV we will use a slightly different URL endpoint. For Basic Auth: /API/ becomes /BasicAuthAPI/ For CSV results you will add the querystring parameter of ResultFormat=CSV

Our example URL for an basic auth using CSV results would then become: http://your.cinchy.instance.domain/BasicAuthAPI/YourQueryDomain/API Test?ResultFormat=CSV

2.2 Using Basic Auth

  1. Launch Power BI and navigate Get Data > Web (Image 7)

6. In the window that launches, you will enter the below text, using your own URL endpoint where highlighted (Image 8): =Csv.Document(Web.Contents("http://your.cinchy.instance.domain/BasicAuthAPI/YourQueryDomain/API Test?ResultFormat=CSV"))

7. Click on the checkmark icon and Power BI will automatically attempt to run the expression (Image 9).

8. Click Edit Credentials > Basic (Image 10). Enter the credentials for a Cinchy User Account that has access to run this query and select the level at which to apply these settings. By default it's the root URL.

This process of entering your credentials won't occur with each query, it's just the first time and then they're saved locally.

10. Click Connect to see your data (Image 11).

11. You can now apply any transformations to the dataset.

In this example we also changed the name from Query1 to Product Roadmap and have edited to use the first row as a header (Image 12).

12. Click Close & Apply. The metadata now shows up on the right hand side and you can begin to use it to create your visualizations (Image 13).

2.3 Using a Personal Access Token

  1. Launch Power BI and navigate to Get Data > Web.

  2. Click Advanced and input the following values (Image 14):

    1. HTTP Request Header Parameters:

      1. In the first text box input Authorization

      2. In the second text box type Bearer + your PAT. For example: "Bearer BGFHFHOJDF76DFDFD777"

  1. Click OK.

  2. Click Load to use the query data in Power BI.

  3. You can now apply any transformations to the dataset.

In this example we also changed the name from Query1 to Product Roadmap and have edited to use the first row as a header (Image 15).

  1. Click Close & Apply. The metadata now shows up on the right hand side and you can begin to use it to create your visualizations (Image 16).

2.4 Using a Bearer Token

  1. Launch Power BI and navigate to Get Data > Web.

  2. Click Advanced and input the following values (Image 17):

    1. HTTP Request Header Parameters:

      1. In the first text box input Authorization

      2. In the second text box type Bearer + your token. For example: "Bearer eyUzI1NiIsImtpZCI6IkE4M0UwQTFEQTY1MzE0NkZENUQxOTFDMzRDNTQ0RDJDODYyMzMzMzkiLCJ0eXAiO"

  1. Click OK.

  2. Click Load to use the query data in Power BI.

3. Tableau

Cinchy exposes a Tableau Web Data Connector that provides access to Cinchy Saved Queries as data sources in Tableau. Tableau versions 2019.2+ are supported.

An active internet connection is required in order to use the Web Data Connector.

3.1 Prerequisites

To get started, you must add a record into the Integrated Clients table in the Cinchy domain with the below values.

Column

Value

Client Id

tableau-connector

Client Name

Tableau

Grant Type

Implicit

Permitted Login Redirect URLs

Permitted Logout Redirect URLs

Permitted Scopes

Id, OpenId, Email, Profile, Roles

Access Token Lifetime (seconds)

3600

Show Cinchy Login Screen

Checked

Enabled

Checked

3.2 Connecting From Tableau

  1. Launch Tableau

  2. Under Connect -> To a Server select the Web Data Connector option

  3. Enter the URL from the Permitted Login Redirect URLs field on the Integrated Clients record created under the Prerequisites section above

  4. The Cinchy login screen will appear, enter your credentials

  5. Select one or more queries to add to your data set. The result of each query will be available as a Table in Tableau. If a query has parameters, you will be prompted to provide the parameter values before you can add it to your collection.

  6. Click the Load button

The Cinchy query results will now be accessible for you to create your visualization.

If needed, to generate a new Personal Access Token (PAT).

URL Parts: This is the Query API URL that you created in the section.

Image 3: Advanced Settings
Image 4: Load

If needed, to generate a Bearer Token.

URL Parts: This is the Query API URL that you created in the section.

Image 5: Advanced Settings
Image 6: Load

Power BI connects to queries within Cinchy, therefore prior to using any of the connection methods below you will need to create one that represents your dataset. Once created, you will need to copy down the , located as a green button on the right-hand side of the Execute Query screen.

If needed, to generate a new Personal Access Token (PAT).

URL Parts: This is the Query API URL that you created in the section.

If needed, to generate a Bearer Token.

URL Parts: This is the Query API URL that you created in the section.

Image 17

follow the documentation here
follow the documentation here
follow the documentation here
follow the documentation here
Prerequisites
Prerequisites
Prerequisites
Prerequisites
https://<your Cinchy URL>/Tableau/Connector
https://<your Cinchy URL>/Tableau/Connector
REST API URL endpoint
REST API URL endpoint
Image 1: Blank Query
Image 2: Add the query as your source
Image 7: Get Data > Web
Image 8: Enter your expression
Image 9
Image 10
Image 11
Image 12
Image 13
Image 14
Image 15
Image 13