Our premium data service allows plugin users to access remote databases (SQL Server, PostgreSQL, Oracle, MS Acces, MariaDB, and MySQL) and remote data files (CSV, JSON, and XML) from the WordPress back-end and front-end.
The plugin is able to handle multiple premium data servers. Each server has to be enabled separately and enabled on a WordPress server before it can be used.
Premium data server wpdafree.youniquedata.com is available for free for all premium users. Premium users are not paying for this service, but there are no uptime or resource guarantees. Please use this server for non-critical information provisioning and testing purposes or as a gateway to transfer external data sources to your WordPress database.
Enabling the service #
Start WP Data Access and press the Settings icon on the toolbar. Next click the tab PDS.
Select server wpdafree.youniquedata.com and press the Submit button. A request will be sent to our server. The server will check your account. If your account is valid and active you will see a page that allows you to enter a password used for your remote database connection.
Enter a strong password and make sure you remember your password. You will need it to enable the connection. Use the icon to view your password before you send your request.
Some activities on our premium data server run unattended. If an error occurs, you can read it from your Data Explorer. Enter an email address if you want to receive the results of unattended action via email as well.
Confirm the disclaimer and click the Create my premium data services account button.
This will create your database account on the selected premium data server. When the account is created successfully, you are sent to a page that allows you to enable the service on your WordPress server.
Enter the password you entered during account creation and click the Enable my premium data services on this server button.
A remote database connection is added to your WordPress server. If you have a multi-domain license, this step needs to be performed on each server individually.
Congratulations! Your premium data services is now ready to use. 🙂
Open your Data Explorer and select wpdafree.youniquedata.com from the database drop-down list. You can now start to add remote database connections and remote data files from the connect icon.
I’ve looked through the documentation but could not find the information regarding that proxy service for remote DB connection.
here is my situation.
msSQL db of an ERP is located in local company network behind firewall and with no “outlets” whatsoever
wp woocommerce located in another location.
current flow for updating stock quantity:
every 30 min the ERP runs an xml export and sends to sFTP to wp-server
on wp side. a cron imports the xml into woo_db
the issue is with 20K rows, and the 30 min interval is too slow.
in order to change it to event based async updates I see 3 options
1. write a windows app on msSQL which updates via WP_REST_API
2. use a middleware like zapier (quite costly for big datasources)
3. a wp_plugin with direct connect
from what i see, wp data access would still use a gateway to connect, thus act as a middleware(?), only with no uptime guarantee. sure enough the db mapping logic would be on wp side rather than on the middleware, but that is no use if the proxy is down.
none the less, i need to open the firewall. whitelisting the ip of the proxy and a port from wpdafree.youniquedata.com
how often does the ip of this domain change?
even if no update times are quaranteed, what is the historical uptime of the server?
i see the name is registered in Germany, which is great, is the server also located in GErmany?
lastly, what about data protection? both dsvgo and end-to-end encyption?
thanks a lot for your answer and i am really looking forward using your pluing.
Hi Tom,
You can connect to a remote database using your own proxy server (no “middleware”), but this will require proper setup on your side.
The steps to do that are outlined in Heterogeneous Connections. Please look through all the referenced links on the page.
Hope this helps! If you have more questions, please send us a message using our contactpage. 🙂
Hi,
I am trying to set up a remote SQL server database connection through premium data services and need to know which IP address should I whitelist on the SQL server for the connection. Initially, I had the WordPress server IP address whitelisted on the SQL Server end, but looks like that won’t work as the connection is actually established from the proxy server: wpdafree.youniquedata.com. Do I just ping it to get its IP address (85.215.166.92) or do you have a specific IP address you provide?
Also, how does WP Access work after I create the database table in the proxy server. Whenever I query the proxy server data table, will it fetch the data from the source or store locally and fetch in a periodic basis?
Thank you for a quick response as I need to get this set up asap.
Hi Viji C,
The IP Address (85.215.166.92) is correct.
With this, please set it up to make sure it connects to:
wpdafree.youniquedata.com (IP: 85.215.166.92)
post: 3306
using sockets
Let us know how it goes.
For your other question, it would fetch the data from the source as it’s a remote database.
I hope this helps!
If you have more questions, feel free to message us via the contact form here: https://wpdataaccess.com/contact/
Thanks, Aaron. Just to clarify, when I set up the connection via Premium Data Services, I use the port number 1433 (which ever is the port that is opened on the SQL Server side)? or 3306?
Regarding the data, thank you for confirming no data is stored in the proxy server and it is just a passthrough to fetch the data from the source every time it is queried.
I cannot connect to my remote database (phpmyadmin on a local host) in any way, with the same data, I can connect without any problem using a program in Python. I configure the connection and it always gives an authentication failure. On the other hand, although I have the service activated in the Settings – PDS menu and the rdb:wpdafree.youniquedata.com database in the list, I get the error: ERROR – Remote database rdb:wpdafree.youniquedata.com not available.
Hi Daniel,
Are you connecting from your local site? Unfortunately, our PDS seem to have issues with working on local sites. We already reached out to localwp about this but they haven’t responded back.
You can try connectin manually without using our premium data service. The steps are outlined here: Connect to SQL Server
Feel free to send us a message if you have other questions.