New bundle, new features in Pimcore Reports

Stefano Viani

Management

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
  • MSSQL
  • 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 info@blackbit.de contact.

About the Author

As Executive Director of Blackbit digital Commerce GmbH, Stefano Viani manages all areas of the agency in the offices in Göttingen, Hamburg, Berlin and Kiev. His passion is the development of marketing strategies and their implementation in concrete measures.

In his free time, Stefano is passionate about riding his motorbike or working out in the gym.