Extend the Value of Your Amazon Aurora Database with Astera Centerprise

By |2020-10-21T23:37:58+00:00October 21st, 2020|

Amazon Aurora is a MySQL and PostgreSQL compatible relational database, designed by AWS, and widely used by modern enterprises to manage their transactional data. Aurora database utilizes Amazon’s unique, scalable cloud architecture to deliver superior availability and performance than traditional MySQL and PostgreSQL databases.

For Astera Centerprise users, this translates to an agile and web-scalable Aurora database that can be integrated with several on-premise and cloud systems, including SAP HANA, Snowflake, Salesforce, SQL Server, and more. Leveraging the built-in connectors for Amazon Aurora MYSQL and PostgreSQL users can achieve seamless, zero-code connectivity to enterprise backend systems. Once extracted, source data can be consolidated in a single data repository or BI dashboard through native integrations.

Execute Code-Free Aurora Database Integrations

Centerprise’s Amazon Aurora connectors can be used as source and destination endpoints to facilitate data transfer between the database and other enterprise systems. The drag-and-drop interface of the software can be easily configured with a few clicks to point towards a specific table in the Aurora MySQL and Postgres databases.

The built-in connectors address the following requirements of enterprise users:

  • Enable connectivity to a range of structured, semi-structured, and unstructured data sources to create a 360-degree view of enterprise assets.
  • Offer both incremental and full crawls so that the user gets updated data as and when required.
  • Create custom tables in the Amazon Aurora databases or modify/update an already existing one to enable easy data sharing between stakeholders and partners.
  • Transform and query Amazon Aurora data using DB Lookup, Database Write Strategies, SQL Statement Lookup, and Run SQL Script to leverage the enterprise data for reporting, analysis, and operational tasks.
  • Ensure optimal performance and reduced query execution time for complex integration jobs by offloading high-volume data processing to the scalable Aurora databases using the pushdown optimization.

Astera Centerprise makes it easier for users to connect, manage, and analyze data stored in Aurora databases by integrating them in a dataflow or workflow using the intuitive UI.

Read and Write Data Using the Built-In Aurora MySQL and PostgreSQL Connectors

To illustrate the functionality of the drag-and-drop connectors and how Centerprise streamlines Aurora integrations, let’s consider the following examples:

amazon aurora database connectivity

Integrating Amazon Aurora MySQL database with the SQL Server database

The above screenshot shows a simple dataflow that reads data from the Aurora MySQL database, applies conditions on it based on business specifications, and transfers it to the SQL Server database.

To configure the source connector, simply drag-and-drop the Database Table Source object from the Toolbox onto the designer window, specify the database provider, and enter the connection details. Next, specify the database table properties by selecting an existing table or creating a new one, and select the preferred Read Strategy.

Aurora PostgreSQL can also be configured in the same way.

aws aurora database

Configuring source connector and specifying database properties

Once the source Aurora MySQL connector is configured, the object can be mapped with other transformations, databases, file formats, and more to execute ETL processes.

Similar to the source connector, both Aurora MySQL and PostgreSQL can be configured at destination endpoints as well for data loading and sharing. The following example shows a dataflow that writes data into the Aurora PostgreSQL database after filtering the raw data.

Writing data into the Amazon Aurora PostgreSQL database

Once the connection has been established to the Aurora database, the user is taken to the Properties screen where they can specify database table properties and Data Load Options. Running the dataflow will write the processed data onto the destination Aurora PostgreSQL table.

Specifying destination table properties

Specifying destination table properties

Centerprise leverages Aurora’s operational value, high-performance, and scalability to enable enterprise users to integrate data from any system without compromising on performance.

Drive Organizational Efficiency with Enhanced Connectivity

The code-free, easy-to-use environment and reusable features of Astera Centerprise promote fast development and deployment of ETL pipelines. The out-of-the-box connectivity of the platform enables Amazon Aurora connectivity with a range of ERP systems, CRMs, databases, cloud sources, file formats, data warehouses, and more. Factor in the automation features, and you can eliminate manual efforts from your Aurora integrations for faster time-to-insights.

Test-drive the new Amazon Aurora MySQL and PostgreSQL connectors in Astera Centerprise by downloading the free trial version.