Optional VPN Database Access
Unrestricted back end access to your data with a secure VPN tunnel.
This allows knowledgeable IT staff to perform queries, reports, data manipulation, including imports, or other database tasks as well as develop integrations with other software.
Requirements & Setup
The agency will need the following:
-
Requires both dedicated network hardware and personnel with expertise in configuring and managing an IPSec tunnel. We additionally require a static IPv4 address for the tunnel endpoint.
-
Data access tools, such as Power BI, to access the SQL Server database.
We will coordinate the setup of a client VPN or IPSec tunnel with AWS, our hosting provider. Once the tunnel is set up, you will be provided with an IP Address, port number and SQL Server credentials, allowing your IT staff to access production, archive, and training databases. Then you will be able to access your databases directly through the VPN tunnel with either read-only or read-write privileges, depending on your preferences.
Agreement & Security Concerns
To use VPN Database Access, you must sign our User Agreement stating you understand anyone with access to the VPN Database Access feature will have complete, unrestricted access to your database. Unrestricted access grants your IT staff the ability to perform all types of actions to the database, including damaging the entire database or accidental deletions. Use caution when assigning IT staff access to the back end of your database and securely store the VPN Database Access login information.
Create and perform queries, imports, exports, or live integrations with other software.
Q&A
Click the plus symbol (+) to expand the section.
General VPN Database Access Information
We will automatically update production databases to incorporate the latest features and bug fixes. This will help enhance the overall performance of our services.
Scheduled Maintenance:
To minimize any potential disruption, these updates will be scheduled during non-peak hours. We carefully plan updates to minimize inconvenience to your operations.
Notification Process:
Before each scheduled update, we will send you advance notice to keep you informed about the upcoming changes.
Support for Older Versions:
All customers are required to update to the most recent version of ChildPlus within 14 days of an update notification.
Data Security:
Rest assured that the security of your data remains our top priority. Keeping your software updated is a proactive measure to strengthen the security of your data.
Improved Performance:
By keeping your production database updated and current, we aim to improve the overall performance and responsiveness of our systems, ensuring a seamless experience for you and your staff.
DevTest Databases:
DevTest databases are available upon request for any agency that needs to test mission-critical customizations against an updated version of ChildPlus before their production database update.
Using VPN Database Access & Reports
Data Restoration
With VPN Database Access, your IT staff can create an unlimited number of database queries to manipulate or filter your data even more.
Contact our sales department for more information on using our Optional VPN Database Access services!
There is an additional cost to using this feature.