blackbit_digital_commerce / pimcore-report-external-database
Access data from external databases for Pimcore reports
Installs: 17
Dependents: 0
Suggesters: 0
Security: 0
Stars: 1
Watchers: 2
Forks: 1
Open Issues: 0
Type:pimcore-bundle
This package is auto-updated.
Last update: 2024-10-23 11:55:15 UTC
README
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 info@blackbit.de.