Data sync sources

Cinchy Event Broker

Cinchy Event Broker/CDC

Cinchy Table

Cinchy Table

Cinchy Query

Cinchy Query

Binary 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.

Binary file

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.

Copper

Delimited file

Delimited file

Dynamics 365

Microsoft Dynamics 365 functions as an interconnected CRM, ERP, and productivity suite that integrates processes, data, and business logic.

Dynamics

Dynamics 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.

Dynamics 2015

DynamoDB

Amazon DynamoDB is a managed NoSQL database service that's offered by Amazon as part of the AWS portfolio.

DynamoDB

Excel

Excel

Fixed-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

Fixed width file

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.

Kafka Topic

LDAP

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.

LDAP

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.

MongoDB collection

MongoDB 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.

MongoDB collection (Cinchy event)

MS SQL Server (query and table)

MS 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.

DynamoDB

Oracle (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).

Oracle (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.

Parquet

Polling event

Polling event

REST 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.

REST API

Salesforce 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 Object (Bulk API)

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.

Salesforce platform event

Salesforce 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.

Salesforce push topic

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.

Snowflake

SOAP 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.

SOAP 1.2 web service

SAP 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.

SAP SuccessFactors

Last updated