1-855-999-5288 [email protected]

Products
- SQL Server Based Integration
  SSIS Integration Toolkit
  
  Dynamics 365 (CRM/AX/NAV/CDS)
  
  Directory Services
  
  HubSpot
  
  Marketo
  
  Microsoft Dynamics GP
  
  Microsoft Dynamics SL
  
  Microsoft Project Server
  
  Microsoft SharePoint
  
  NetSuite
  
  Oracle CRM On Demand
  
  Oracle Marketing Cloud
  
  QuickBooks
  
  Salesforce
  
  Team Foundation Server
  
  SAP
  
  SSIS Productivity Pack
  
  A collection of SSIS components that enable great productivity:
  
  SSIS component collection that enables great productivity:
  
  Premium Data Flow Components
  
  HTTP / Web Services
  
  JSON and XML Processing
  
  Big Data
  
  Message Queuing
  
  NoSQL Databases
  
  See All Components
  
  Ultimate Edition
  
  Integration Toolkit
  Ultimate Edition
  
  Interested in getting all the above?
  The Ultimate Edition provides access to all of our SSIS integration toolkits and the SSIS Productivity Pack under one single commercial license.
  
  See Ultimate Edition
- JDBC Drivers
  
  JDBC Driver Pack
  
  Easily connect your Java-based applications to enterprise data while leveraging advanced security, intelligent caching, and batching.
  
  Secure and Efficient Java Data Access
  
  Seamlessly connect enterprise applications to your Java applications using our JDBC Driver Pack, leveraging simplified connectivity for efficient and structured data access.
  
  See JDBC Driver Pack Features
- Integration Gateway
  
  Real-Time Integration Made Easy
  
  KingswaySoft Integration Gateway, offers real-time data integration.
  
  Real Time Integration
  
  Publish to message queues and file systems when Integration Gateway receives a notification from your online services.
  
  Works with Virtually Any Applications
  
  Connect Integration Gateway to any modern cloud applications that support webhooks.
  
  Always Listening
  
  Whenever there is an event happening, Integration Gateway is ready to take the message and publish the changes as needed to facilitate real-time integration.
  
  Keep Your Data Always Updated
  
  With Integration Gateway, you can easily trigger real-time jobs to have your data updated instantaneously.
  
  See Integration Gateway Features
Solutions
- By Technology
  
  SSIS-Based Data Integration
  
  Java-Based Connectivity
  
  Realtime
  Integration
  
  Data Synchronization
  
  Data Warehousing
  
  CRM
  
  ERP
  
  HRIS
  
  See All Tech Solutions
- By Data Type
  
  Relational Data
  
  Unstructured Data
  
  Big Data
  
  XML Data
  
  Transactional Data
  
  Cloud Data
  
  Analytical Data
  
  JSON Data
  
  See All Data Type Solutions
- By Industry
  
  Education
  
  Ecommerce & Retail
  
  Energy & Utilities
  
  Government
  
  Health Services
  
  Financial Services
  
  Manufacturing
  
  Technology
  
  See All Industry Solutions
- By Department
  
  Accounting
  
  Customer Service
  
  Marketing
  
  Human Resources
  
  Supply Chain
  
  Sales
  
  Security
  
  Development
  
  See All Dept Solutions
- Developer Productivity Tools
  
  Conversion
  
  File Format Support
  
  Encryption & Compression
  
  Data Quality & Comparison
  
  Data Generation & Anonymization
  
  Premium Data Flow Components
  
  Premium File Pack Components
  
  Premium Task Components
  
  REST Components
  
  Timing & Automation
  
  Template Merge
  
  Test & Simulation
  
  See All Productivity Tools
Connectors
Purchase
Support & Services
Blog
About Us

Premium Data File Integration

via SSIS Productivity Pack

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 Productivity Pack

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 Productivity Pack

Premium Data File Integration
is available in the
SSIS Productivity Pack

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 Productivity Pack, 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 SSIS 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: