For connecting to on-premise databases located in local networks or on users’ computers behind the firewall Skyvia offers Agent application. You install this application on your computer and start it, and then it connects to Skyvia and serves as a secure gateway between Skyvia and a local database server.
In order to use the Agent application, you need to create an Agent object on Skyvia first. Agent object represents an instance of the Agent application, running on a specific computer. It has a unique Key, that is used to identify a specific agent.
If you need to install agent application onto multiple computers to connect to databases in different local networks, you need to create multiple Agent objects.
As well as the other Skyvia objects, agents are available in the object list, and you can manage them as well as other Skyvia objects. You can organize them into folders, edit or delete them, view their dependencies, etc.
To display only agents, switch to the Agents tab on the workspace toolbar. For connections, Skyvia displays the information when it was created and last modified. The following Quick Actions are available for connections:
- Test Agent — checks whether the corresponding Agent application instance is running and connected to Skyvia.
- View Dependencies — displays the list of the Skyvia connections that use this agent or are used by it.
By clicking a certain agent, you are transferred to its details. Here you can download the Agent application and key, test agent, edit its name or delete it.
Creating and Using Agents
To create an Agent object, in the New menu, click Agent (on the left).
Agent object is immediately created, and its details are opened.
Here you can provide a meaningful name instead of the default ‘Untitled’ (just click the name to edit it), download the Agent application installer and its Key.
Download the Agent application installer and install it. Then download the agent key file and place it to the folder where the Agent application is installed. Note that the key file must have name
skyvia_security_agent.key. If you downloaded keys multiple times, browser may rename files in order to avoid overwriting already existing one. In such case, rename it back in the Agent application folder.
After this, you may start the Agent application.
How Agent Works
Agent application is installed on a computer in the same local network, in which your database server is running. The Agent application must be running and have access to the Internet in order to work.
After Agent is started, it connects to the Skyvia service and keeps this connection. Since it initiates the connection itself, it does not need a dedicated external IP. When Skyvia connects to a local database via Agent, it sends the corresponding request to Agent, and it connects to the database and performs all the database interaction inside the local network, to which it is installed.
This is why you should specify database connection parameters when creating an agent connection so as if you are connecting from the computer where the Agent is installed.
Agent sends the requested data to Skyvia and receives the data to load into the database encrypted, over HTTPS protocol. This protocol is usually allowed in firewalls, so usually Agent requires no additional firewall settings. Besides, Agent’s protocol is often more optimized for exchanging data over the Internet than database protocols. It uses less granulated operations and performs less roundtrips between the Agent and Skyvia.
Proxy Settings for Agent
If the computer you install the Agent on is connected to the Intenet via a proxy server, you need to configure your agent and set up proxy parameters. This can be done by editing the Skyvia.Agent.Client.exe.config file in the agent installation directory and providing the necessary values for parameters in the appSettings section:
<appSettings> <add key="proxyHost" value="" /> <add key="proxyPort" value="" /> <add key="proxyUsername" value="" /> <add key="proxyPassword" value="" /> </appSettings>
You need to specify the following values:
- proxyHost - Domain name or IP address of your proxy server, by which it can be accessed from the computer, where Agent is installed.
- proxyPort - Proxy port to use.
- proxyUsername - If your proxy server requires authentication, specify the username to use for authentication on proxy server.
- proxyPassword - If your proxy server requires authentication, specify the password to use for authentication on proxy server.
<appSettings> <add key="proxyHost" value="192.168.0.17" /> <add key="proxyPort" value="3128" /> <add key="proxyUsername" value="test" /> <add key="proxyPassword" value="11111" /> </appSettings>