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.
Skyvia Agent Application to Easily Connect to On-Premise Data
Despite the 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 a united ecosystem of their cloud and on-premise data.
There are different integration scenarios of on-premise and cloud solutions:
When performing integration of on-premise and cloud sources, a company can face the following challenges:
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 provides an Agent application – a secure tunnel application to load data between databases and Skyvia.
Just install the application and download the key – and connect immediately. No need to use port forwarding and server's firewall configuration.
No direct access from the Internet to your database server needed. Data is loaded securely encrypted by Agent, using its unique encryption key.
Agent protocol is better optimized for data access over the large distances - it requires fewer roundtrips, ensuring higher performance.
Agent runs on a local computer having access to both Skyvia and the local database. It only loads data between Skyvia and databases, while main work is performed in the cloud
Create an Agent object on Skyvia and download the Agent application and a unique encryption key from there.
Install the application on a local computer having access to the Internet and local database and place the key file in its folder.
Run the agent. After this, you can create agent connections to your databases on Skyvia.
Agent is a secure tunnel application to load data between databases that establishes a connection to Skyvia service and can connect to database servers in a local network
No need for static IP for local databases
No need for firewall configuration in most cases
All the data is securely encrypted in transit
Low local resource use, most work is done in the cloud
Agent application offers an optimized protocol for data access over large distances, which can provide significantly better performance of data integration packages. In our tests, replication to MySQL went almost two times faster!
Agent protocol uses high-level operations – it exchanges data with Skyvia in large compressed batches, reducing the number of roundtrips between Skyvia and the Agent application. Note that performance gain depends on the database location and other factors.
Quickly and easily import data from on-premise databases to cloud apps directly, no CSV files needed.
Copy cloud data to your on-premise database with almost no effort. Keep the copy up-to-date automatically.
Get your data available over the Internet via OData or SQL API with no effort! Publish only the tables and columns you want.
Query on-premise data to Excel and Google Sheets with Skyvia’s Google Sheets and Excel add-ins, and refresh data in workbooks in one click.
Query and manage your on-premise databases from anywhere via Skyvia’s online SQL client - only a web browser is required.
Skyvia offers a Google Data Studio connector, which can be used to analyze on-premise data, not available from the Internet directly.
Skyvia offers an ODBC driver and ADO.NET provider, which you can use to connect to your on-premise databases that are not available from the Internet directly.
Easily sync and load data between two different on-premise database servers in different locations.
Integrate on-premises databases with cloud apps without opening them to the Internet directly!
Get started for free