1. Create Connections to Data Sources You Want to Connect
First, you need to tell Skyvia how to connect to cloud apps or databases you want to integrate. For this, open the Connections page and create connections to your data sources. For these connections you need to specify a connection Name that will be used to identify the connection and other connection parameters that are data source-specific. For more information about the required parameters please see the documentation for the corresponding data source.
2. Check Out Gallery of Predefined Integration Packages
Skyvia already has a number of predefined integrations available in the Predefined Integrations Gallery. Open the gallery and see if there is a suitable template for your needs. If yes, select this template and read its description. Then, you only need to select connections to your data sources for this template and maybe do few small configuration steps, listed in the description.
3. Create Your Own Integration Package
If there is no suitable template in the Predefined Integrations Gallery, you will need to configure such integration yourself.
In Skyvia you define your data integration operations as packages. Skyvia supports different kinds of packages for different use cases, and it is necessary to select a correct package kind for your needs:
If you want to:
|•||migrate your existing data between different cloud applications or databases - use Import Package.|
|•||import data from CSV files to a cloud application or database - use Import Package.|
|•||automate import of CSV files from a file storage service or FTP - use Import Package.|
|•||create an exact copy of cloud application data in a database or cloud data warehouse - use Replication Package. |
|•||create a copy of a cloud data in a database or data warehouse and keep it in sync with the source cloud app automatically - use Replication Package. |
|•||export cloud or database data to a CSV file - use Export Package. You may also use our Query tool.|
|•||configure a regular automatic data export to a file storage service - use Export Package. |
To know more about Skyvia's integration package kinds, please read How It Works.
To find out more about specific package kinds, read the corresponding section of our documentation: Import, Export, Replication, and Synchronization.
4. Define a Schedule to Automate Your Integration Operation
In Skyvia, you automate your integration packages by setting up a schedule for the package to run automatically. Skyvia has powerful scheduling settings allowing you to run your package up to every minute. You can find detailed information abote automating your data integration with Skyvia in the Scheduling Packages topic.
5. Monitoring Package Execution
After you configured your integration package, you may run it at any time manually, and if you configured a schedule for the package, it will run automatically on the schedule. Skyvia logs all the package runs, and you may check it at any time. See Package Run History for more information.