Data sync sources
Cinchy Event Broker
pageCinchy Event Broker/CDCCinchy Table
pageCinchy TableCinchy Query
pageCinchy QueryBinary file
A binary file is a computer file that's not a text file, and whose content is in a binary format consisting of a series of sequential bytes, each of which is eight bits in length.
You can use binary files from a Local upload, Amazon S3, or Azure Blob Storage in your data syncs.
Some benefits of using binary files include:
Better efficiency via compression
Better Security through the ability to create custom encoding standards.
Unmatched Speed, since the data is stored in a raw format, and isn't encoded using any character encoding standards, it's faster to read and store.
Copper
Copper is a Customer Relationship Management (CRM) software. Copper is a tool focused on automation and simplicity, most known for its Google Workspace integration.
pageCopperDelimited file
pageDelimited fileDynamics 365
Microsoft Dynamics 365 functions as an interconnected CRM, ERP, and productivity suite that integrates processes, data, and business logic.
pageDynamicsDynamics 2015
Dynamics 2015 is a legacy CRM predecessor to Microsoft Dynamics 365. Mainstream end of life support finished in January 2020, with extended end of life support finishing in January 2025.
pageDynamics 2015DynamoDB
Amazon DynamoDB is a managed NoSQL database service that's offered by Amazon as part of the AWS portfolio.
pageDynamoDBExcel
pageExcelFixed-width file
A fixed-width file is a file that has a specific format which allows for the saving of information in an organized fashion. The data is arranged in rows and columns, with one entry per row. Each column has a fixed-width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file.
Advantages of using a fixed-width file include:
It's a compact representation of your data
It's fast to parse because every field is in the same place in every line
Kafka Topic
Apache Kafka is an end-to-end event streaming platform that:
Publishes (writes) and subscribes to (reads) streams of events from sources like databases, cloud services, and software applications.
Stores these events durably and reliably for as long as you want.
Processes and reacts to the event streams in real-time and retrospectively.
Those events are organized and durably stored in topics. These topics are then partitioned over a number of buckets located on different Kafka brokers.
Event streaming thus ensures a continuous flow and interpretation of data so that the right information is at the right place, at the right time for your key use cases.
pageKafka TopicLDAP
LDAP (Lightweight Directory Access Protocol) is a mature, flexible, and well supported standards-based mechanism software protocol for enabling anyone to locate data whether on the public internet or on a corporate intranet.
Common uses of LDAP include when:
A single piece of data needs to be found and accessed regularly;
Your organization has a lot of smaller data entries;
Your organization wants all smaller pieces of data in one centralized location, and there doesn't need to be an extreme amount of organization between the data.
MongoDB collection
MongoDB is a scalable, flexible NoSQL document database platform known for its horizontal scaling and load balancing capabilities, which has given application developers an unprecedented level of flexibility and scalability.
pageMongoDB collectionMongoDB collection (CDC triggered)
MongoDB is a scalable, flexible NoSQL document database platform known for its horizontal scaling and load balancing capabilities, which has given application developers an unprecedented level of flexibility and scalability. Data changes in Cinchy (CDC) can be used to trigger a data sync from a MongoDB data source to a specified target. The attributes of the CDC Event are available to use as parameters within the Data Source Definition to narrow the scope of the request. For example, a lookup.
pageMongoDB collection (Cinchy event)MS SQL Server (query and table)
pageMS SQL Server (query and table)ODBC query
Open Database Connectivity (ODBC) is a standard API for accessing database management systems (DBMS).
ODBC is the database portion of the Microsoft Windows Open Services Architecture (WOSA), which is an interface that allows Windows-based desktop applications to connect to multiple computing environments without rewriting the application for each platform.
pageDynamoDBOracle (query and table)
Oracle Database is a relational database management system, commonly used for running online transaction processing, data warehousing and mixed database workloads. The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL).
pageOracle (query and table)Parquet
Apache Parquet is an open source data file format built to handle flat columnar storage data formats. Parquet operates well with complex data in large volumes and is known for its both performant data compression and its ability to handle a wide variety of encoding types.
pageParquetPolling event
pagePolling eventREST API
A REST API is an application programming interface that conforms to the constraints of REST (representational state transfer) architectural style and allows for interaction with RESTful web services.
REST APIs work by fielding requests for a resource and returning all relevant information about the resource, translated into a format that clients can easily interpret (this format is determined by the API receiving requests). Clients can also modify items on the server and even add new items to the server through a REST API.
pageREST APISalesforce object (bulk API)
Salesforce is a cloud-based CRM software designed for service, marketing, and sales.
Salesforce objects are database tables that permit you to store data that's specific to an organization. Salesforce objects are of two types:
Standard Objects: Standard objects are the kind of objects that are provided by salesforce.com such as users, contracts, reports, dashboards, etc.
Custom Objects: Custom objects are those objects that are created by users. They supply information that's unique and essential to their organization. Custom objects are the heart of any application and provide a structure for sharing data.
Salesforce platform event
Salesforce is a cloud-based CRM software designed for service, marketing, and sales.
Salesforce Platform Events are secure and scalable messages that contain data. Publishers push out event messages that subscribers receive in real time.
pageSalesforce platform eventSalesforce push topic
Salesforce is a cloud-based CRM software designed for service, marketing, and sales.
Push Topic events provide a secure and scalable way to receive notifications for changes to Salesforce data that match a SOQL query you define.
You can use PushTopic events to:
Receive notifications of Salesforce record changes, including create, update, delete, and undelete operations.
Capture changes for the fields and records that match a SOQL query.
Receive change notifications for only the records a user has access to based on sharing rules.
Limit the stream of events to only those events that match a subscription filter.
Snowflake
Snowflake is a fully managed SaaS that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time/shared data.
Snowflake enables data storage, processing, and analytic solutions.
pageSnowflakeSOAP 1.2 web service
SOAP (Simple Object Access Protocol) is an XML-based protocol for accessing web services over HTTP.
SOAP can communicate between different operating systems using different technologies and programming languages. You can use SOAP APIs to create, retrieve, update or delete records, such as passwords, accounts, leads, and custom objects, from a server.
pageSOAP 1.2 web serviceSAP SuccessFactors
SAP SuccessFactors solutions are cloud-based HCM software applications that support core HR and payroll, talent management, HR analytics and workforce planning, and employee experience management.
pageSAP SuccessFactorsLast updated