New bundle, new features in Pimcore Reports

Luisa Sens

Text & Social Media

09 Apr 2021 Pimcore Import, Export

The latest Blackbit bundle in the Pimcore Marketplace allows you to access external databases and map the data in your your Pimcore Reports.

Neues Bundle, neue Funktionen im Stammdatenmanagment

This innovative product adds another useful feature to your master data management via Pimcore: With the new bundle, you can access external databases in Pimcore reports. For this purpose an additional user-definedreport type 'External Database' under the 'Custom Reports' section of your Pimcore backend. The feature supports all SQL-based databases supported by PHP Data Objects. Among them for example:

  • MySQL
  • Oracle
  • PostgreSQL
  • ODBC
  • and other

Easy query of external databases

Since database vendors use different SQL dialects for some SQL functions, this bundle includes a simple text field for entering enter your SQL query. For example, this allows you to use LIMIT for MySQL or ROWNUM for Oracle. Furthermore it allows it the execution of complex statements with subSelects, Unions etc.
All this is possible with the standard SQL report adapter that comes with
Pimcore is delivered, only with difficulty or at all not possible.

In combination with the Pimcore Data Director Bundle there is also the possibility to not only display data from external databases, but to import them directly into Pimcore.

All Pimcore versions from 5.4 are compatible with the new bundle. If you are interested in it, you can purchase it directly via the Pimcore Marketplace or contact contact.

About the Author

Luisa manages the social media channels of many clients, develops strategies, creates concepts and helps out actively and with great attention to detail in numerous campaigns and projects.

She prefers to take her mind off things when it comes to outdoor exercise and creative projects: Capturing the world with her camera, designing stationery and holding the results in her hands. Whether it's a framed photo or an artistically crafted card on special paper - Luisa loves it when the boundaries between digital and analog blur.