Over 250 native connectors to capture data from internal and external source systems. PurpleCube supports over 250 connectors for both source and target.

PurpleCube’s connectors extract data from various source systems including the most RDBMS, files, legacy datasets like COBOL files, SaaS applications, REST APIs, Social Media platforms etc. Extraction can be in done in bulk mode if supported by the source or through regular JDBC. Below are the major highlights:

• Parallel and bulk extraction/load options

• Encryption & compression options for data transfer between source & target

• Derivations, audit columns and parameterization.

PurpleCube’s Data Studio adds real-time data ingestion feature to PurpleCube’s core platform. Built on top of the controller-agent architecture, Data Studio enables organization to perform change data capture (CDC) from RDBMS like Oracle, MySQL, MSSQL and ingest streaming data from JMS based message brokers and Kafka. Underneath, it has a stack of  trusted technologies such as Kafka, Kafka Connect & Zookeeper. Bring your own enterprise Kafka or use the PurpleCube bundled community stack.

The real time large sets of data can be moved from source to target using data connect. Here, the source connectors are used to pull the real time data and loaded to target sink connectors. To process the data connect flow, various source and sink connectors are being utilized. The real time data is loaded directly from source to sink connector by traversing through various steps.

The steps include selecting source connector, table selection (data objects), selecting sink connector, assigning source and sink properties, reviewing the details and upon submission, the data connect is successfully created.