Cinchy Data Sync Documentation
Cinchy Data Sync Documentation
Cinchy Data Sync Documentation
Cinchy Data Sync Documentation
Overview
Release Notes
Installation Guide
Upgrades & Config Changes
Frequently Asked Questions
Builder Guide
Overview
Subscribing to Event Streams
Configuring a Data Sync
XML Config Reference
Data Validation
Transformations
Supported Data Sources
Cinchy Query
Cinchy Table
Copper CRM Entity
Delimited File
Dynamics 365 Entity
Microsoft Excel Worksheet
Fixed Width File
LDAP ObjectCategory
ODBC Table
ODBC Query
Oracle Table
Oracle Query
REST API
Salesforce Object (Bulk API)
Salesforce Platform Event
Salesforce Push Topic Event
SOAP 1.2 Web Service
MS SQL Server Table
MS SQL Server Query
SAP SuccessFactors
Supported Sync Targets
Sync Data Command
Common Design Patterns
Testing a Data Sync
Promoting a Data Sync
Scheduling a Data Sync
Monitoring
Cinchy Platform Documentation
Powered by GitBook

MS SQL Server Query

  • connectionString: the encrypted connection string query

  • query: the select statement

<SqlServerDataSource
query="Select * from dbo.employees"
connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU=">
<Schema>
<Column name="employee_id" ordinal="1" dataType="Number" />
<Column name="name" ordinal="2" dataType="Text" />
</Schema>
<Filter/>
</SqlServerDataSource>
Previous
MS SQL Server Table
Next
SAP SuccessFactors
Last updated 7 months ago