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.
On-Premise Data Integration
Skyvia Agent Application to Easily Connect to On-Premise Data
Easily Integrate On-Premise and Cloud 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 data is transferred from one source and stored in another - once or periodically. There are on-premises solutions on the market for this, but Skyvia can offer a number of benefits.
- When on-premises data is queried on-demand, for example, integrating an on-premises database with Looker Studio (formerly, Google Data Studio) or linking it to Salesforce as an external data source.
On-Premise Data Integration Challenges
When performing integration of on-premise and cloud sources, a company can face the following challenges:
- An on-premise database server is usually behind a restrictive firewall, which needs to be configured to allow access.
- Direct access of a database server to the Internet can be not allowed because of security reasons.
- A database server may not have a dedicated IP.
- An on-premise data integration tool can put a lot of load onto a computer it is running on.
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 provides an Agent application – a secure tunnel application to load data between databases and Skyvia.
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 - it requires fewer roundtrips, ensuring higher performance.
How Agent Works
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
Create an Agent object on Skyvia and download the Agent application and a unique encryption key from there.
Install
Install the application on a local computer having access to the Internet and local database and place the key file in its folder.
Connect
Run the agent. After this, you can create agent connections to your databases on Skyvia.
Agent Benefits
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
Optimized Performance
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.
What Skyvia Сan Do for You
Load On-Premise Data to Cloud
Quickly and easily import data from on-premise databases to cloud apps directly, no CSV files needed.
Load Cloud Data to On-Premise
Copy cloud data to your on-premise database with almost no effort. Keep the copy up-to-date automatically.
Publish On-Premise Data via Web API
Get your data available over the Internet via OData or SQL API with no effort! Publish only the tables and columns you want.
Get On-Premise Data to Excel and Google Sheets
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 On-Premise Databases Online
Query and manage your on-premise databases from anywhere via Skyvia’s online SQL client - only a web browser is required.
Analyze On-Premise Data with Looker Studio
Skyvia offers a Looker Studio connector, which can be used to analyze on-premise data, not available from the Internet directly.
Develop Software Working with Your On-Premise Data
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.
Integrate Different On-Premise Servers
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