Download the PHP package blackbit_digital_commerce/pimcore-report-external-database without Composer
On this page you can find all versions of the php package blackbit_digital_commerce/pimcore-report-external-database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download blackbit_digital_commerce/pimcore-report-external-database
More information about blackbit_digital_commerce/pimcore-report-external-database
Files in blackbit_digital_commerce/pimcore-report-external-database
Package pimcore-report-external-database
Short Description Access data from external databases for Pimcore reports
License GPL-3.0-or-later
Homepage https://pimcore.blackbit.de
Informations about the package pimcore-report-external-database
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.
Access external database via Pimcore report
- Select
Externaldb
as report source - Configure external database connection and SQL query
- Access the external database data as with a usual Pimcore report
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 [email protected].