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.

link
No Configuration Required

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

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

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

Step 1

Create

Create an Agent object on Skyvia and download the Agent application and a unique encryption key from there.

Step 2

Install

Install the application on a local computer having access to the Internet and local database and place the key file in its folder.

Step 3

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

1

No need for static IP for local databases

2

No need for firewall configuration in most cases

3

All the data is securely encrypted in transit

4

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.

optimized

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