

Get in touch

Download Plugin Now
  • Follow
  • Follow
WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
a
M
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
Download Plugin Now

Remote Databases

  • MySQL | MariaDB
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
  • WordPress user ID in SQL

Premium Data Services

  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Overview
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
  • Remote Data Files
    • Overview
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
  • Advanced features
    • Performance
    • Indexes
View Categories

Remote wizard

The remote connection wizard is part of our premium data services and allows premium users to make heterogeneous external data sources available to their WordPress back-end and front-end. Two types of remote data sources are supported:

  1. Remote database connections
  2. Remote data files (no programming skills or database knowledge required)
WP Data Access - Remote connection types

Remote database connections #

Remote database connections are supported for the following database management systems:

  • MariaDB | MySQL
  • Microsoft SQL Server
  • PostgreSQL
  • Oracle
  • Microsoft Access (handled as a remote data file)

The remote database needs to be accessible from our data server. Data is not cached or replicated on our server (only Microsoft Access files are cached).

Remote data files #

The following file types are supported:

  • Microsoft Access MDB
  • Microsoft Access ACCDB
  • CSV file
  • JSON file
  • XML file

Remote data files need to be accessible via a public URL. The remote file is loaded (cached) onto our data server and imported into our database. A database table is created automatically and requires zero configuration. A refresh interval can be defined per remote data file, which reloads the data file and updates the database table automatically.

Setup #

To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.
To do so, please follow these instructions.

Usage #

Plugin tools #

Tables created from a remote database connection or remote data file, are available to all WP Data Access tools. Just select your table to create a publication, project or chart as you would do with a table stored in your WordPress database.

Custom PHP code #

Tables can be accessed from PHP code as well. Here is a template:

<?php

function heterogeneous_connection_example() {
	$wpdadb = WPDataAccess\Connection\WPDADB::get_db_connection( 'rdb:wpdafree.youniquedata.com' );
	$rows   = $wpdadb->get_results( 'select * from my_table' );
	foreach ( $rows as $row ) {
		// Process table row...
	}
}

add_action('plugins_loaded', 'heterogeneous_connection_example');

?>

The code example above connects to remote database rdb:wpdafree.youniquedata.com. Class WPDADB is a sub class of WordPress class wpdb. If you are fimiliar with the wpdb class you can easily use wpdb method like query, get_results, insert, update, delete, and so on, to access your remote data.

Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2025-02-12
START HERE

2 Comments

  1. Mustafa Çetin
    Mustafa Çetin on 2024-07-07 at 3:21 pm

    Hello,

    We purchased the premium version of the WP Data Access plugin and connected to the Mssql server. We can pull tables from the remote database, but can we write new data to the remote database via the plugin?
    We would like to transfer data from a remote database to a different database installed on the Website. Can you help us with this? We are waiting for your support, thank you in advance.

    Reply
    • Kim Leong
      Kim Leong on 2024-07-08 at 3:19 am

      Hi Mustafa,

      If you’re connected to your remote database using our PDS service, your tables will be recreated on our server without a primary key.

      Remote primary keys are not recognized automatically. You must add a primary key to enable transactions (you can use the Query Builder or Data Designer).

      Hope that helps! Let us know if you have more questions.

      Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • Remote database connections
  • Remote data files
  • Setup
  • Usage
    • Plugin tools
    • Custom PHP code
WP Data Access
  • Follow
  • Follow
Links
$

Imprint

$

Privacy policy

$

Cookie policy

Get in touch
$

Contact us

$

Free support forum

$

Premium support

Resources


WordPress plugin directory



YouTube tutorials

Copyright © 2025 | All Right Reserves

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}