As an end-to-end data integration solution, Astera Centerprise is designed to improve efficiency across a wide variety of enterprise architectures. Key to this objective is our range of out-of-the-box connectors, which allow users to seamlessly link their dataflow pipelines to a disparate array of databases, applications, file systems, and storage platforms at both source and destination. Now, we’re looking to push those capabilities even further with our new SAP HANA connector.
Why We Chose SAP HANA
Touted by SAP executives as the fastest-growing product in the company’s history, SAP HANA has created an outsized impact in the database market over the past decade. This widespread adoption made the platform an obvious choice for our data integration solution.
For Users of High-Performance Hardware
SAP HANA’s in-memory capabilities allow the database to process inputs more quickly than its counterparts that store their data on disk. The database is also optimized to take advantage of IT architectures boasting multiple CPU cores, MPP, and large cache memories. These features are further augmented by advanced partitioning and query optimization tools.
By adding SAP HANA to our list of connectors, we aimed to help organizations leveraging the database’s performance-focused functionalities.
For Analytics-Focused Users
SAP HANA combines OLTP and OLAP structures in a single database, allowing both transactional and analytics-based queries to be processed simultaneously.
These capabilities are enabled by HANA’s columnar storage structure, which groups together data at a more granular level in smaller files according to their data type. This arrangement facilitates data compression and speeds up aggregate calculations or any other functions required for advanced analysis.
With SAP HANA as a source, we hope to hasten the data-to-insights journey for users that rely on the database’s analytics-ready focus.
For Source-Agnostic Users
SAP HANA database integrates easily with third-party applications and other data sources through its built-in virtualization functionality. The platform also supports a variety of programming languages including C++, Python, and SQL for advanced querying.
As a result, we can bolster the number of sources our own platform supports through SAP HANA, including a number of HANA-based apps available through SAP’s library as well as numerous web and mobile apps that have been built on the database platform.
How the SAP HANA Connector Works in Astera Centerprise
Like any of our database connectors, SAP HANA can be integrated into a dataflow or workflow as either a source or destination through our intuitive drag-and-drop UI. Users can configure this connector to point towards a relevant table and data to this object as required.
We have also aligned the SAP HANA connector with certain database-specific functionalities. First, because SAP HANA is used for development as well as reporting and analytics, the database generally contains multiple schemas. To prevent all of these structures from importing into Astera Centerprise when the SAP HANA database source is selected, the configuration window provides an option to define source table schema. As a result, only relevant schemas are brought into our interface, which substantially improves dataflow performance at runtime.
Second, to accommodate SAP HANA’s columnar storage capabilities, we’ve provided an option that allows users to define the output type for tables in their destination database. Using the dropdown menu, you can select either row-stored or column-stored formatting for your target object.
Selecting Column-Based Output in SAP HANA Database Destination
Apart from the features mentioned above, the database will function as usual at either source or destination. This means that you can use SAP HANA tables with Database Lookups, SQL Query Lookups, and SQL scripts in a workflow and apply various advanced transformations to these objects in Astera Centerprise. To optimize performance, Astera Centerprise can also push down these operations to the SAP HANA database in ELT mode.
Stay Tuned for More Updates!
Over the new year, we’ll further expand the range of out-of-the-box connectors and transformations supported in Astera Centerprise. For more information on any of our current and upcoming functionalities, feel free to reach out to our team for a no-obligation consultation, or check out our product for yourself by downloading a trial version of our latest release, Astera Centerprise 8.0.