Premium Data File Integration

via SSIS Integration Toolkit

The Premium Data File components facilitate integration of Avro, ORC and Parquet files with any applications or data source, including Databricks, Power BI, Hadoop, and Kafka, to name just a few.

Download Purchase

What other systems and applications can you sync with big data files?
Click here for more solutions.

The Premium Data File components are designed to simplify big data integration, enabling you to seamlessly read and write data from high-performance Avro, ORC, and Parquet files.

Premium Data File Source Component

Read from Modern File Formats

Effortlessly extract structured data from Avro, ORC, and Parquet files stored anywhere, from local servers to the cloud.

Connect to a wide range of file systems including Local File, SFTP, FTPS, SFTP, Amazon S3, Azure Blob, Azure Data Lake Storage, Box, Dropbox, Hadoop, OneDrive or SharePoint, and many more.
Use the Document Designer to visually build or import the schema of your files for handling complex nested data.
Handle complex data types like arrays, maps, and structs with ease, defining how they are mapped to your SSIS data flow.
Use SSIS expressions to dynamically update file paths and other properties at runtime, making your packages flexible and reusable.

See SSIS Integration Toolkit

SSIS Premium Data File Source

SSIS Premium Data File Destination

Premium Data File Destination Component

Write to Modern File Formats

Effortlessly extract structured data from Avro, ORC, and Parquet files stored anywhere, from local servers to the cloud.

Write data to Avro, ORC, and Parquet formats with comprehensive data type conversion handling.
Build the destination schema visually or import it from an existing file. Use the Diagram View to easily create complex data hierarchies.
Optimize your files for size and performance by choosing from a variety of compression formats, including Snappy, GZip, and Zlib.
Configure how the component handles errors, with options to Fail on error or Redirect rows to error output for detailed logging.

See SSIS Integration Toolkit

Premium Data File Integration
is available in the
SSIS Integration Toolkit

Download Purchase Help Manual

Premium Data File Data Integration Made Easy

Our solution is easy to use, offering code-less integration between the Premium Data File components and a local file, FTPS, SFTP, Amazon S3, Azure Blob, Azure Data Lake Storage, Box, Dropbox, Hadoop, OneDrive or SharePoint* connection. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Premium Data File components are available within the Big Data components of our SSIS Integration Toolkit, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions for enterprise applications including Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

More Big Data Components

Our Big Data components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular big data solution. In addition to Premium Data File, we support the following Big Data services:

Avro

CDM

Databricks

EDI Source & Destination

Google BigQuery

Hadoop

HDFS

HL7 Support

ORC

Parquet

Power BI

PrestoDB

Salesforce Einstein (Wave) Analytics

Tableau Hyper

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Help ManualsINTEGRATION TOOLKIT

Testimonials

Case Studies

Video Tutorials