WP Business Intelligence Documentation

  1. Connect to your database.

    -Navigate to the plugin WP Business Intelligence>Database Connections.  Click “Add New”.
    -Fill out the form then “Create”.
    WordPress Business Intelligence Plug-in instructions on creating a database connection />

  2. Make an appropriate query.

    -Navigate to the plugin WP Business Intelligence>Queries.  Click “Add New”.
    -Fill out the form then “Create”. Your returned results will appear at the bottom of the page. A good way to test your database connection is to query “SHOW TABLES” and then all of your table names should appear at the bottom of the screen(as highlighted in the red circle). There are many ways to customize your data based on your MySQL query. Please look-up some tutorials if you are not familiar with writing queries to a database.
    WordPress Business Intelligence Plug-in instructions on creating query

  3. Create the data table.

    -Navigate to the plugin WP Business Intelligence>Data Tables.  Click “Add New”.
    -Fill out the form then “Create”.
    -Your example table will appear at the bottom of the page. You can copy the shortcode that is below your example table (highlighted in the red circle) to paste the table into a page or post.
    WordPress Business Intelligence Plug-in instructions on creating a responsive data table

  1. Connect to your database.

    -Navigate to the plugin WP Business Intelligence>Database Connections.  Click “Add New”.
    -Fill out the form then “Create”.
    WordPress Business Intelligence Plug-in instructions on creating a database connection />

  2. Create an appropriate query.

    -Navigate to the plugin WP Business Intelligence>Queries.  Click “Add New”.
    -Fill out the form then “Create”.
    -Your returned results will appear at the bottom of the page. A good way to test your database connection is to query “SHOW TABLES” and then all of your table names should appear at the bottom of the screen(as highlighted in the red circle). There are many ways to customize your data based on your MySQL query. Please look-up some tutorials if you are not familiar with writing queries to a database.
    WordPress Business Intelligence Plug-in instructions on creating query

  3. Create the chart.

    -Navigate to the plugin WP Business Intelligence>Charts.  Click “Add New”.
    -Select chart type from the drop down menu. Click “Create”.
    -Fill out the form then “Create”. You will need assign columns to the different axis of your charts from the drop down menu. Then click “Save Changes”
    -You can copy the shortcode that is below your example chart (highlighted in the red circle) to paste the table into a page or post.
    WordPress Business Intelligence Plug-in instructions on creating chart

  1. Create new variables

    -Navigate to the plugin WP Business Intelligence>Variables.  Click “Add New”.
    -Fill out the form then “Create”.

  2. Pass the created variable into a query.

    -Navigate to the plugin WP Business Intelligence>Queries.  Click “Add New”.
    -Fill out the form then “Create”.

  3. Now requests to yoursite.com/path-to-your-chart?limit=10 will return 10 results.  Requests to yoursite.com/path-to-your-chart, will return 5 results.
  1. Find the versions of the operating system that PHP is running on, the PHP version and the Microsoft SQL Server version.
  2. Consult the support matrix to find out which version Microsoft PHP Drivers you need.  For example if you have PHP 7.2, and SQL Server 2017, then you’ll need Microsoft PHP Drivers version 5.3.
  3. Download and install the Microsoft PHP Drivers on the PHP server.  There are guides for some OSs at the bottom of this page that can guide you through the installation of the latest versions.
  4. Enable the PHP extensions: pdo_sqlsrv and sqlsrv.

If you have done everything correctly you can run the command “php -m” to show which module are installed.  If it’s working, you should see that sqlsrv and pdo_sqlsrv are included in the output.

WP Business Intelligence F.A.Q.

  1. Once you purchase the Pro version of the plugin you will receive an email with the zipped plugin files.
  2. Upload the uncompressed folder wp-business-intelligence-lite to the /wp-content/plugins/ directory.
  3. Activate the plugin through the ‘Plugins’ menu in WordPress.

WPBI is very robustly tested.  It’s tested to run on the following

  • PHP 5.6 and up
  • WordPress 4.4.0 and up
  • MySQL 5.5 and up including 8.0
  • MariaDB 5.5 and up including 10.x
  • It works with any version of Microsoft SQL Server that PHP can connect with using the official Microsoft PHP Drivers.  See their compatibility matrix for more information, but it should works all the way back to SQL server 2008.
You are likely to get the error “PHP Notice: session_start(): ps_files_cleanup_dir: opendir(/tmp/.priv) failed: Permission denied (13)” if your webhost does not allow access to the /tmp/ folder used by PHP. This is common among webhosting providers. You may create your own /tmp/ folder and add its location to your PHP.ini file to fix this error message.
WordPress plugins can automatically deactivate for any number of reasons including other admins deactivating them, malware, corrupted files, and a lack of web hosting resources. With WP Business Intelligence the most common cause of this is due to a limit on the number of concurrent connections by webhosts such as HostGator, Blue Host, and Ionos. If you have shared web hosting contact your provider about either increasing your limit or upgrading to a larger hosting package that increases or removes this limit.
Our plugin should work on any web hosting provider. However, most shared web hosts limit the number of concurrent connections per account. If your host has limited the number of connections and you display several charts/graphs per page it is likely you will quickly go over this limit and it may trigger the plugin to deactivate automatically to keep your website live. We recommend VPS, Dedicated, or Cloud hosting without limits on concurrent connections.