Data sync sources
Last updated
Last updated
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.
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
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.
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.
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.
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.
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 Events are secure and scalable messages that contain data. Publishers push out event messages that subscribers receive in real time.
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 enables data storage, processing, and analytic solutions.
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.
is a Customer Relationship Management (CRM) software. Copper is a tool focused on automation and simplicity, most known for its Google Workspace integration.
functions as an interconnected CRM, ERP, and productivity suite that integrates processes, data, and business logic.
Dynamics 2015 is a legacy CRM predecessor to Microsoft Dynamics 365. Mainstream end of life support finished in , with extended end of life support finishing in January 2025.
is a managed NoSQL database service that's offered by Amazon as part of the AWS portfolio.
is an end-to-end event streaming platform that:
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
(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.
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.
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.
Open Database Connectivity () is a standard API for accessing database management systems (DBMS).
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).
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.
is a cloud-based CRM software designed for service, marketing, and sales.
is a cloud-based CRM software designed for service, marketing, and sales.
is a cloud-based CRM software designed for service, marketing, and sales.
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.
solutions are cloud-based HCM software applications that support core HR and payroll, talent management, HR analytics and workforce planning, and employee experience management.