1.
Download and install the Agent application.
On-Premise Data Integration
Skyvia Agent Application to Easily Connect to On-Premise Data
Skyvia Agent Application to Easily Connect to On-Premise Data
Despite constantly growing share of cloud solutions on the market, many businesses still have on-premise databases and solutions. With the adoption of cloud technologies, they need to have united ecosystem of their cloud and on-premise data.
Integration of cloud and on-premise data usually bring the following challenges:
- On-premise database server is usually behind a restrictive firewall, which needs to be configured to allow access.
- A database server may even not have access to the Internet directly or a dedicated IP, so port forwarding needs to be configured.
Skyvia's Solution
While retaining the possibility to connect to databases directly from the Internet, Skyvia also offers a much simpler way to connect to on-premise servers with little to no configuration. It offers an Agent application – a secure tunnel to load data between databases and Skyvia.
No Configuration Required
Just install the application and download the key – and connect immediately. No need to use port forwarding and server's firewall configuration.
Security
No direct access from the Internet to your database server needed. Data is loaded securely encrypted by Agent, using its unique encryption key.
Performance
Agent protocol is better optimized for data access over the large distances and much less roundtrips required, ensuring higher performance.
Advanced Access Control
If you are worried that your local network resources can be freely accessed from outside of the network via Agent, you may add a configuration file with allowed connections and their aliases. This improves the security in two ways:
- The agent is restricted to only the listed connections. It won't connect to anything else.
- All the connection credentials are stored only in this configuration file and are never sent outside. You specify only the alias on Skyvia.
What Skyvia can Do for You
Integrate On-Premise and Cloud Data
Quickly and easily integrate cloud applications and on-premise databases and get all of your data working together.
Integrate Different On-Premise Servers
Easily sync and load data between two different on-premise database servers in different locations.
Publish On-Premise Data via OData
Get your data available via OData over the Internet with no effort! Publish only tables and columns you want. Other data won't be available via the endpoint.
Query and Manage On-Premise Databases Online
Our web-based SQL editor allows you to execute SQL against on-premise databases from anywhere. You can query and manage them with SQL whenever you need with just a web browser.
How It Works
Skyvia is a SaaS platform that runs all the operations in the cloud. You manage everything in a convenient GUI in web browser. Only the optional Agent application is installed locally.
Configure
Define your connections (with or without agent) and configure Skyvia for necessary operations with no coding
Schedule
Schedule your integrations or backups with powerful schedule editor, and they will run automatically in the cloud.
Monitor
View the detailed log of all the operations online whenever you need.
How to Use Agent
To use this agent, you need to do the following:
2.
Create an Agent object on Skyvia and download a key file from it.
3.
Place the key file to the folder where Agent is installed and run the Agent application.
Skyvia Agent for Linux
Ubuntu, Debian, etc.
Coming soon
Skyvia Agent for macOS
Coming soon