5️⃣
Cinchy Platform Documentation
Cinchy v5.8
Cinchy v5.8
  • Data Collaboration Overview
  • Release notes
    • Release notes
      • 5.9 release notes
      • 5.8 Release Notes
      • 5.7 Release Notes
      • 5.6 Release Notes
      • 5.5 Release Notes
      • 5.4 Release Notes
      • 5.3 Release Notes
      • 5.2 Release Notes
      • 5.1 Release Notes
      • 5.0 Release Notes
  • Support
  • Glossary
  • FAQ
  • Deployment guide
    • Deploying Cinchy
      • Plan your deployment
        • Deployment architecture
          • Kubernetes architecture
          • IIS architecture
        • Deployment prerequisites
          • Single Sign-On (SSO) integration
            • Enable TLS 1.2
            • Configure ADFS
            • AD Group Integration
      • Kubernetes
        • Disable your Kubernetes applications
        • Change your file storage configuration
        • Configure AWS IAM for Connections
        • Use Self-Signed SSL Certs (Kubernetes)
        • Deploy the CLI (Kubernetes)
      • IIS
  • Upgrade guide
    • Upgrade Cinchy
      • Cinchy Upgrade Utility
      • Kubernetes upgrades
        • v5.1 (Kubernetes)
        • v5.2 (Kubernetes)
        • v5.3 (Kubernetes)
        • v5.4 (Kubernetes)
        • v5.5 (Kubernetes)
        • v5.6 (Kubernetes)
        • v5.7 (Kubernetes)
        • v5.8 (Kubernetes)
        • Upgrade AWS EKS Kubernetes version
        • Update the Kubernetes Image Registry
        • Upgrade Azure Kubernetes Service (AKS)
      • 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)
        • v5.7 (IIS)
        • v5.8 (IIS)
      • Upgrading from v4 to v5
  • Guides for using Cinchy
    • User Guide
      • Data Browser overview
      • The Admin panel
      • User preferences
        • Personal access tokens
      • Table features
      • Data management
      • Queries
      • Version management
        • Versioning best practices
      • Commentary
    • Builder Guide
      • Best practices
      • Create tables
        • Attach files
        • Columns
        • Data controls
          • Data entitlements
          • Data erasure
          • Data compression
        • Formatting rules
        • Indexing & partitioning
        • Linking data
        • Table and column GUIDs
        • System tables
      • Delete tables
        • Restore tables, columns, and rows
      • Saved queries
      • CinchyDXD
        • Overview
        • DXD workflow
        • Package the data experience
        • Install the data experience
        • Release package
        • Changelog
        • References
          • Cinchy DXD CLI reference
          • Data Experience Definitions table
          • Data Experience Reference table
      • Multilingual support
      • Integration guides
    • Administrator Guide
    • Additional guides
      • Monitor and Log on Kubernetes
        • Grafana
        • OpenSearch dashboards
          • Set up Alerts
        • Monitor via ArgoCD
      • Maintenance
      • Cinchy Secrets Manager
      • GraphQL (Beta)
      • System properties
      • Enable Data At Rest Encryption (DARE)
      • Application experiences
        • Network map
          • Custom node results
          • Custom results in the Network Map
        • Set up experiences
  • API Guide
    • API overview
      • API authentication
      • API saved queries
      • ExecuteCQL
      • Webhook ingestion
  • CQL
    • Overview
      • CQL examples
      • CQL statements overview
        • Cinchy DML statements
        • Cinchy DDL statements
      • Cinchy supported functions
        • Cinchy functions
        • Cinchy system values
        • Cinchy User Defined Functions (UDFs)
          • 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
        • Math 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
    • CQL functions reference list
  • Meta-Forms
    • Introduction
    • Install Meta-Forms
      • Deploy Meta-Forms (Kubernetes)
      • Deploy Meta-Forms (IIS)
    • Forms data types
    • Meta-Forms Builder Guide
      • Create a dynamic meta-form with tables
      • Create a dynamic meta-form example with Form Designer
      • Add links to a form
      • Rich text editing in forms
  • Data syncs
    • Get started with data syncs
    • IIS installation
      • Install Connections
      • Install the Worker/Listener
      • Install the Connections CLI
    • Build data syncs
      • Data sync types
      • Design patterns
      • Sync actions
      • Columns and mappings
        • Calculated column examples
      • Advanced settings
        • Filters
        • Variables
        • Auth requests
        • Request headers
        • Post sync scripts
        • Pagination
      • Batch data sync example
      • Real-time sync example
      • Schedule a data sync
      • Connection functions
    • 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
      • Mongo event
      • MongoDB collection (Cinchy event)
      • MS SQL Server (query and table)
      • ODBC Query
      • Oracle (query and table)
      • Polling event
        • Polling event example config
      • REST API
      • REST API (Cinchy event)
      • SAP SuccessFactors
      • Salesforce Object (Bulk API)
      • Salesforce platform event
      • Salesforce push topic
      • Snowflake
        • Snowflake source example config
      • SOAP 1.2 web service
      • SOAP 1.2 web service (Cinchy Event Triggered)
    • Data sync destinations
      • Cinchy Table
      • DB2 table
      • Dynamics
      • Kafka Topic
      • MongoDB collection
      • MS SQL Server table
      • Oracle table
      • REST API
      • Salesforce
      • Snowflake table
      • SOAP 1.2 web service
    • Real-time sync stream sources
      • The Listener Config table
      • Cinchy Event Broker/CDC
      • Data Polling
      • Kafka Topic
      • MongoDB
      • Salesforce Push Topic
      • Salesforce Platform Event
    • CLI commands list
    • Troubleshooting
  • Other Resources
    • Angular SDK
    • JavaScript SQK
Powered by GitBook
On this page
  • Version 2.0.0
  • Version 1.7.0
  • Version 1.6.2
  • Version 1.6.1
  • Version 1.6.0
  • Version 1.5.1
  • Version 1.5.0
  • Version 1.4.0
  • Version 1.3.4
  • Version 1.3.3
  • Version 1.3.2
  • Version 1.3.1
  • Version 1.3.0
  • Version 1.2.2
  • Version 1.2.1
  • Version 1.2.0
  • Version 1.1.4
  • Version 1.1.3
  • Version 1.1.2
  • Version 1.1.1
  • Version 1.1.0
  • Version 1.0.0
  • Known issues in version 1.0.0
  • Version 0.9.1
  • Known issues in version 0.9.1
  1. Guides for using Cinchy
  2. Builder Guide
  3. CinchyDXD

Changelog

Version 2.0.0

  • Git Sync: Cinchy DXD can now sync into a repository folder, compatible with local git repositories.

  • Artifact Structure: Individual files stored in a standardized format for easier Git diffing.

  • PowerShell Removal: No longer includes PowerShell scripts in install packages. Use Cinchy DXD for all operations.

  • Sync GUID Support: Allows forwarding of Sync GUIDs from origin environments.

Version 1.7.0

  • Enhanced Data Sync: Now supports syncing of Secrets, Listener Configurations, Webhooks, and Views.

    • Note: Views must be explicitly defined; Secrets automatically include External Secrets Manager.

  • Script Management: Define Pre-Install and Post-Install Scripts in Data Experience Definition.

    • Auto run: Scripts run automatically during Install.

    • Order: Scripts executed alphabetically.

    • Deprecated: -ps and -pr command line options removed.

  • Metadata Skip: Automatically omits non-defined or obsolete metadata during sync.

Version 1.6.2

  • Fixed: Resolved validation logic issue for link display columns with more than two table hops.

Version 1.6.1

  • Group Sync: Now occurs in two stages to manage parent/child references.

  • Pre-Export Checks: Error messages for common configuration issues.

  • Optimized Sync: Improved accuracy and reduced errors in linkColumn references.

  • Binary Column Fix: Binary columns now excluded from Reference Data configurations.

Version 1.6.0

  • Skip Parameter: Use -skip to exclude specific Tables or Columns during sync.

  • Export Notifications: Alerts for tables needing pre-export action. TSQL only.

  • Force Install: Use -y flag to overwrite existing Models records.

  • Optional Encryption: New support for encrypted Data Experience Definitions.

    • Key Generation: Use keygen command to create an encryption key.

  • Pre-Install Scripts: Optional CQL script execution.

  • Fixes: Resolved issues with Views and System Colours loading order.

Version 1.5.1

  • System Requirements: Now requires SQL Server 2017 or PostgreSQL 14.3 for Cinchy installation.

Version 1.5.0

  • CLI Requirements: Removed the need for Cinchy Connections CLI.

  • Switch Updates: Various command line switches removed or repurposed:

    • -h, -sso, -c, -t are removed.

    • -e and -z are repurposed for install errors and log outputs.

    • -m is new for ignoring model errors during install.

  • Error Handling: Provides options to pause and handle errors during installation. Use -m to override default behavior.

  • Error Output: Use -d to specify location for Connections Sync Error files.

Version 1.4.0

  • Version Support: Compatibility with Cinchy v5 and Cinchy.Connections.CLI v5.

  • View Initialization: Initializes Views data in both source and target environments.

  • Deployment Cleanup: Removes DXDF CLIs post-deployment.

  • Encryption Fix: Resolves password encryption issue for passwords with $.

  • Cross-Platform: Adds support for Windows, MacOS, Linux with PowerShell 7+.

Version 1.3.4

  • Encrypt Command: New command for encrypting passwords. Usage: .\CinchyDXD.ps1 encrypt -t "TextToBeEncrypted".

Version 1.3.3

  • Fix: Resolves issue with Reference data.

Version 1.3.2

  • Compatibility: Must be used for deployments to Cinchy v4.20.x and above.

  • Patch Instructions: Specific steps for updating older DX packages for compatibility.

Version 1.3.1

  • Install Warnings: Version differences during install are now warnings, not errors.

  • Encoding Fix: Resolves character encoding issue in model file generation.

Version 1.3.0

  • Post-Install Scripts: New support for running CQL scripts post-install.

  • Reference Data Filter: Adds a new filter option for Reference Data CLI configuration.

  • Table Sync Fix: Resolves error when no tables are defined in the DXD.

  • Sync Fix: Resolves sync issue for names containing &.

Version 1.2.2

  • Compatibility: Updated for Model Loader changes in Cinchy v4.16.0.

Version 1.2.1

  • REFDATA Sync: Linked column source dataTypes now set to Text.

Version 1.2.0

  • ModelLoader Enhancements: Supports column drops, updates, and table/domain renaming.

  • Version Matching: Installation only allowed when source and target Cinchy versions match.

  • Special Character Fix: Resolved REFDATA loading issue with Domains or Tables containing &.

Version 1.1.4

  • Order Fix: Resolved issue causing Reference Data to load out of order.

Version 1.1.3

  • Duplicate Row Fix: Fixed issue creating duplicate rows in Table Access Control.

Version 1.1.2

  • DataType Fix: Corrected REFDATA CLIs not setting correct dataType for Date columns.

Version 1.1.1

  • Authorization Fix: Resolved issue where DXD was updating unauthorized users in various elements.

Version 1.1.0

  • Cleanup: Deletes deprecated config data during target install.

  • Force Install: More comprehensive SQL script for complete data removal.

  • Bug Fixes: Resolved issues in Formatting Rules, Table Access Controls, and Views sync.

  • Dependency: Views sync issue fixed with Cinchy 4.6.0.

Version 1.0.0

  • Initial Release: First official version.

Known issues in version 1.0.0

  • CinchyCLI Compatibility: Specific attribute setting needed for proper synchronization with CinchyCLI version 4 and above.

Version 0.9.1

  • Beta Release: Pre-release for beta testing.

Known issues in version 0.9.1

  • Unsupported: Use version 1.0.0 or later for supported functionality.

PreviousRelease packageNextReferences

Last updated 1 year ago