WP Data Access

Description

WP Data Access is a powerful data administration, publication, and development tool. This highly customizable plugin allows users to perform database-related tasks from the WordPress dashboard through an intuitive user interface, enabling the creation of fully responsive publications, charts, and data administration pages. No programming skills required!

The plugin supports more complex features for advanced users, including remote database and file access, master-detail pages, lookups, inline editing, advanced search options, and WordPress role management integration. Additionally, it acts as an additional layer around your WordPress database, allowing you to add database tables and view specific functionality such as dynamic hyperlinks and WordPress media library integration.

Programmers can also benefit from the WP Data Access API, which can be used to access remote databases and data files directly from their PHP code.

Data Publisher

The Data Publisher can be used to publish a database table via your WordPress back-end or front-end. This tool can make a publication fully responsive. Key elements of Data Publisher include the ability to easily add export buttons, search panes, the search builder, and to employ professional page styling using the intuitive premium user interface. Advanced and premium features are available for users who want to get the most out of their publications and harness the true power of this tool.

  • Easy level: no coding skills required
  • Advanced level: JSON configuration
  • Expert level: add custom JavaScript functions

  • Global searching and sorting

  • Custom CSS styling [demo]
  • Server-side processing
  • Client-side processing [demo]
  • Export to CSV, Excel, PDF and SQL, Print and Copy buttons (PREMIUM) [demo]
  • Integrated geolocation search (PREMIUM) [demo]
  • Multiple advanced search options (PREMIUM)
  • Interactive Search Builder (PREMIUM) [demo]
  • Interactive Search Panes (PREMIUM) [demo]
  • Custom queries and custom post types (PREMIUM)

Remote database and file access

WP Data Access supports seamless access to several remote databases (SQL Server, Oracle, ProgreSQL, MariaDB/MySQL, and MS Access) and remote data files (CSV, JSON, and XML). To facilitate this access, the remote connection wizard helps premium users set up the connection. However, documentation is available for free users (requires DBMS and OS knowledge and root access).

Database tables created from remote database connections and remote data files are available from all plugin tools. Publications, charts, and projects can utilize these database tables.

Remote SQL Server example

Make sure your SQL Server is accessible. Premium users can use the remote connection wizard to create a database table using a remote connection to your SQL Server.

Remote CSV files example

Make your CSV file available from a public URL. Use the remote connection wizard to load your CSV file into a database table and add an update interval. Maintain your CSV file with your favorite spreadsheet program while WP Data Access synchronizes your table at your desired update intervals.

Charts

Charts are created from SQL queries. Use the Query Builder to manage your queries and copy them into your charts. The Visual Query Builder is a premium feature that can be used by those with little or no SQL knowledge.

  • Google Charts integration
  • Bar, column, line and pie charts, histograms, gauges and data tables are supported [demo]

Geolocation maps

Create a searchable geolocation map from a database table containing geolocation information.

  • Google Maps integration (PREMIUM)
  • Define map settings per table (PREMIUM)
  • Dynamic marker layout configuration (PREMIUM)
  • Use static or user location (PREMIUM)
  • Search map within adjustable radius (PREMIUM) [demo]

Dashboards and widgets

Dashboards are designed for back-end usage. Widgets are highly customizable and can be shown on dashboards (back-end), webpages (front-end), and external websites.

  • Manage all your data in one location
  • Share your data widgets anywhere (PREMIUM)
  • Give specific users and user groups access to locked dashboards (PREMIUM)
  • Allow users to create their own dashboards (PREMIUM)

Query Builder

Execute SQL queries directly from your WordPress dashboard.

  • Work on multiple SQL queries simultaneously (using tabs)
  • Save and reuse queries (for publications and charts)
  • Protects WordPress table structures and data
  • Interactive Visual Query Builder for user with limited SQL knowledge (PREMIUM)

Data Projects and Project Templates

Use Data Projects and Project Templates to write WordPress data apps. Apps can be executed on the back-end or the front-end using shortcodes.

  • Auto generated CRUD pages
  • Parent-child relationships
  • Lookups
  • Remote and local databases
  • WordPress role integration
  • WordPress media library integration
  • Accessible from the WordPress dashboard and public pages
  • DataForms – fully responsive apps for back-end and front-end (PREMIUM) [demo]
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Multiple advanced search options (PREMIUM)

Data Explorer

The Data Explorer helps you to manage local and remote data and databases from a single location.

  • Manage local and remote databases
  • Import SQL and CSV files (supports ZIP for large import files)
  • Exports to SQL, CSV, JSON and XML (supports extremely large table exports)
  • Rename, copy, truncate, drop, optimize and alter tables
  • Change table and column settings (advanced search, geolocation, inline editing and more)
  • Enable WordPress Media Library integration for specific table columns
  • Enable inline editing for specific table columns (PREMIUM)
  • Multiple advanced search options (PREMIUM)

Data Designer

Create and alter tables and indexes using an intuitive user interface.

  • Create and alter tables and indexes
  • Supports reverse engineering and reconciliation

Plugin Settings

WP Data Access is highly customizable. Many detailed plugin settings are available to manage the plugin user interface and behavior.

Useful Links

Screenshots

Installation

(1) Upload the WP Data Access plugin to your blog
(2) Activate it
(3) Navigate to the WP Data Access menu

1, 2, 3 and you’re done!

Reviews

اپریل 18, 2022
Excellent and reliable work and support even in the free version. This plugin is a must for working with your database, saving you precious time. Thank you Passionate Programmers for your work!
اپریل 1, 2022
The free version of the plugin worked like a charm for me. Thank you very much, highly recommended!
مارچ 26, 2022
With this plugin you might do almost anything. A must have to access to data stored on the databases.
مارچ 6, 2022
This is a great plugin. The author Peter is very responsvie and has provided great documentation and code examples. I looked at a number of alternatives but the functionality of this plugin won me over, especially the ability to have a google like search with an empty table on start up. This was exactly what I was looking for! The Premium pricing is also very reasonable. Thanks for an excellent product!
Read all 56 reviews

Contributors & Developers

“WP Data Access” is open source software. The following people have contributed to this plugin.

Contributors

“WP Data Access” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “WP Data Access” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.