Preserving Relations
Powerful mapping settings allow preserving relations between imported data.
ODBC and Amazon S3 Integration
100% cloud solution to automate CSV data loading between ODBC and Amazon S3
Trusted by thousands of organizations around the globe
Simple GUI
Configure your import/export in convenient GUI wizards with no coding.
Flexible Scheduling
Use flexible scheduling settings to automate data export & import.
Detailed Logging
You can find detailed logs for each execution in the package Run History.
Import CSV from Amazon S3 to ODBC
Import CSV files from Amazon S3 to ODBC tables with Skyvia. Powerful mapping features enable you to import data with the structure different from the structure of ODBC objects, use various string and numeric expressions for mapping, etc.
You can run import manually or automatically, on a schedule. For easier import automation, Skyvia supports getting a CSV file from Amazon S3 by a file mask, including a datestamp.
All DML Operations
Skyvia supports INSERT, UPDATE, DELETE, and UPSERT for import to ODBC.
Data Splitting
Skyvia can load data from one CSV file to several related ODBC objects at once.
Export Data from ODBC to Amazon S3
Skyvia is a perfect tool to export ODBC tables to Amazon S3. Automate your data export operation and get rid of redundant manual work!
Compressing Output Files
Skyvia supports zip and gzip compression of result CSV files, allowing you to save storage space.
Powerful Filtering
Create filters with multiple conditions and logical operators to export exactly the data you need.
Related Data Export
Select fields to export from the main ODBC object and all of its related objects.
Integrate ODBC and Amazon S3 with minimal effort and in only a few clicks!