Cinchy Platform Documentation
Cinchy v4.0
Cinchy v4.0
  • Dataware Overview
  • Release Notes
    • 4.1 Release Notes
    • 4.2 Release Notes
    • 4.4 Release Notes
    • 4.5 Release Notes
    • 4.6 Release Notes
    • 4.7 Release Notes
    • 4.8 Release Notes
    • 4.10 Release Notes
    • 4.11 Release Notes
    • 4.12 Release Notes
    • 4.13 Release Notes
    • 4.14 Release Notes
    • 4.15 Release Notes
    • 4.16 Release Notes
    • 4.17 Release Notes
    • 4.18 Release Notes
    • 4.19 Release Notes
    • 4.20 Release Notes
    • 4.21 Release Notes
  • Cinchy Guides
    • User
      • My Network
      • User Preferences
      • Table Features
      • Data Management
      • Commentary
      • Query
    • Builder
      • Best Practices
        • Multi-Lingual Support
      • Tables
        • Creating your first table
        • System Columns
        • Column Types
        • Linking Data
        • Indexing and Partitioning
        • Formatting Rules
        • Data Controls (formerly Design Controls)
          • Table Level Entitlements
          • Column Level Entitlements
          • Row Level Entitlements
          • Erasure
          • Compression
      • Building Forms
      • Saved Queries
        • Creating your first query
        • Displaying Query Results
      • Integration
        • BI Integrations
          • Excel
          • Power BI
          • Tableau
        • Other Integrations
          • SAS
      • Data Experience Deployment
    • Frequently Asked Questions
  • API Guide
    • APIs
      • Authentication
      • Saved Queries
      • ExecuteCQL
      • Webhook Ingestion
  • Deployment Guide
    • Planning
      • Deployment Planning Guide
      • Pre-Requisites
    • Installation
      • Maintenance
      • Migration from 1.x
      • Single Sign-On (SSO) Integration
        • Configuring ADFS
        • AD Group Integration
        • High Number of Groups in ADFS
      • Application Experiences
        • Setting Up Experiences
        • My Data Network
        • Custom Data Network Visualizer
      • Advanced Settings
        • Enable Data At Rest Encryption
        • System Properties
  • Other Resources
    • Cinchy Data Sync
    • Cinchy Meta-Forms
    • Cinchy Meta Reports
    • Cinchy Query Language
    • Angular SDK
    • JavaScript SDK
Powered by GitBook
On this page
  • Pre-Deployment Steps
  • Deployment
  • Post Deployment Steps

Was this helpful?

Export as PDF
  1. Deployment Guide
  2. Installation

Migration from 1.x

Migration prerequisites when upgrading to Cinchy 2.x and later versions from 1.x

PreviousMaintenanceNextSingle Sign-On (SSO) Integration

Last updated 6 years ago

Was this helpful?

Pre-Deployment Steps

  • As "Integrated Apps" table will get modified to "Applets" table after 2.0 upgrade, please save "Integrated Apps" table data by running a select statement on this table. This data will be required to populate new table named "Integrated Clients" after deployment.

  • Please run below Update statement for updating "Integrated App" to "Applet" under "Launcher Objects" table

Pre-Deployment CQL Script
UPDATE [Cinchy].[Cinchy].[Launcher Objects]
SET [Type] = 'Applet'
WHERE [Type] = 'Integrated App'
  • Install .net core Hosting bundle Version 2.1 -

  • Install .Net Framework 4.7.2 on the server

  • Create a new application pool with configuration as "No managed Code" and "Integrated" in IIS manager.

  • Take backup - Cinchy DB, Cinchy Web and Cinchy SSO

Deployment

  • Deploy binaries

  • Assign newly created application pool in Pre-Deployment steps to the Cinchy SSO application

  • Configure appsettings.json file under Cinchy SSO as described below, most of these configurations can be taken from the web.config of previous version of Cinchy SSO

Web.config (Previous location)

appsettings.json (New Location)

appsettings -> CinchyLoginRedirectUri

AppSettings -> CinchyLoginRedirectUri

appsettings -> CinchyPostLogoutRedirectUri

AppSettings -> CinchyPostLogoutRedirectUri

appsettings -> CertPath

AppSettings -> CertificatePath

connectionStrings -> SqlServer

ConnectionStrings -> SqlServer

Below configurations are only required for External login authentication, otherwise can be left as blank

Web.config (Previous location)

appsettings.json (New Location)

appsettings -> SAMLClientEntityId

AppSettings -> SAMLClientEntityId

appsettings -> SAMLIDPEntityId

AppSettings -> SAMLIDPEntityId

appsettings -> SAMLMetadataXmlPath

AppSettings -> SAMLMetadataXmlPath

ExternalIdentityClaimSection -> FirstName -> ExternalClaimName

ExternalIdentityClaim -> FirstName -> ExternalClaimName

ExternalIdentityClaimSection -> LastName -> ExternalClaimName

ExternalIdentityClaim -> LastName -> ExternalClaimName

ExternalIdentityClaimSection -> Email -> ExternalClaimName

ExternalIdentityClaim -> Email -> ExternalClaimName

ExternalIdentityClaimSection -> MemberOf -> ExternalClaimName

ExternalIdentityClaim -> MemberOf -> ExternalClaimName

  • SAMLSSOServiceURL - Configure service endpoint for SAML authentication.

  • AcsURLModule - This parameter is needs to be configured as per your SAML ACS URL. For example, if your ACS URL looks like this - "https:///CinchySSO/identity/AuthServices/Acs", then the value of this parameter should be "/identity/AuthServices"

  • In Cinchy SSO, Log folder will required to be configured under log4net.config and web.config files. Please make sure that Identity under which application pool is running must have access to logs and certificate folder as configured.

  • In Cinchy Web application web.config file, modify "StsAuthorityUri" parameter to remove "identity" keyword from the URL.

    • URL will modify from "https://<your server URL>/SiteName/CinchySSO/identity" to "https://<your server URL>/sitename/cinchysso"

    • Please make sure the sitename and cinchysso is in lower case

Post Deployment Steps

  • Login to Cinchy and follow these below steps to update Launcher Objects table-

    • Go to Design Table

    • Update "Integrated App" link column name to "Applet".

    • Update "Type" choice column's choice from "Integrated App" to "Applet"

  • "Integrated Clients" table would be required to be populated from the data taken from "Integrated Apps" table in pre-deployment steps as shown in below table

Integrated Apps (Old Table)

Integrated Client

Id

Client Id

Login Redirect Url

Permitted Login Redirect URLs

Logout Redirect Url

Permitted Logout Redirect URLs

  • Please check off Query permissions under Design controls of "Users" table for "All Users" row.

  • Upload your organization logo on Admin screen - https://<your server URL>/Cinchy/Admin/Index

https://www.microsoft.com/net/download/dotnet-core/2.1