Contact Contact Show All Awards & Recognition
Contact
Show All Awards & Recognition

Pimcore Reports: Access External Database

not-reviewed

Master Data Management

Author:

Blackbit

Version

Last updated

Contact

info@blackbit.de

Issues

info@blackbit.de

No  Reviewer

Pimcore Reports: Access External Database

Master Data Management

Project Summary

Access data from external databases to be displayed in Pimcore reports


Readme

Report data from external databases

Access data from external databases to be displayed in Pimcore reports


What does this plugin do?

With this Pimcore bundle you get an additional custom report type External Database on the Custom reports page in the Pimcore backend.

It supports all SQL-based databases which are supported by PDO, for example:

  • MySQL
  • Oracle
  • PostgreSQL
  • MSSQL
  • ODBC
  • etc.

As for some SQL features database vendors use different SQL dialects this bundle comes with a simple textarea for entering the SQL query. This allows for example to use LIMIT for MySQL or ROWNUM for Oracle. Furthermore this allows to execute complex statements with sub-selects, unions etc. which is difficult or even impossible with the standard SQL report adapter which gets shipped with Pimcore - so you can also use this bundle to execute complex queries on the Pimcore database.

In combination with the Pimcore Data Director bundle you can not only show data from external databases but also import it to Pimcore.

How to get the plugin

Please write an email to info@blackbit.de.

Review status

not-reviewed

?>

Author:

Blackbit

Version

Last updated

Contact

info@blackbit.de

Issues

info@blackbit.de

No  Reviewer