Announcing the Release of Astera Centerprise 8.2 – Taking Integration Innovations One Step Ahead

By |2020-05-07T16:08:00+00:00May 7th, 2020|

We are pleased to announce the rollout of Astera Centerprise 8.2 for all users. The latest release includes several feature enhancements in terms of connectivity and ease-of-use, further simplifying data integration for enterprise users.

Here’s a brief overview of the new features in Astera Centerprise 8.2:

REST API Browser (Beta)

With this release, we are launching the beta version of the REST API Browser. Making this feature available to general users  allows us to test the component’s functionality and stability under a variety of practical scenarios, before we premiere the finalized version for production use in the next release of Centerprise.

The REST API Browser facilitates easy data retrieval and manipulation from diverse source systems, enabling the creation of a well-connected data eco-system.

Users can consume swagger-compliant APIs by importing a file or entering the URL and making HTTP calls through the REST API Browser. The call object can be integrated with the flow simply by dragging-and-dropping from the Browser onto the designer. Currently, Astera Centerprise supports PUT, GET, POST, PATCH, and DELETE HTTP request methods.

This feature is accessible from the View tab in the Toolbar.

Figure 1: Accessing the REST API Browser from the Toolbar

Figure 1: Accessing the REST API Browser from the Toolbar

Using the REST API Browser, users can configure the connection to the following:

  • Open and private APIs via JSON/YML file – Requires Import File Path
  • Open and private APIs via JSON/YML URL – Requires Import URL
  • Custom APIs – Requires custom API name and Base URL in JSON or YML format

All the APIs present in the URL or file can be viewed and accessed in the REST API Browser along with their call names, as shown below:

Figure 2: List of APIs present in the source URL

Figure 2: List of APIs present in the source URL

Moreover, users can further edit the REST parameters, as well as the input and output layout of a specific call object by right-clicking on it in the Browser.

REST API Browser only works in the integration project. In case a user wants to access it outside the scope of the project, they will need to use a REST API Connection object in their dataflow that contains the base URL.

Figure 3: Using the REST API Browser outside the integration project

Figure 3: Using the REST API Browser outside the integration project

Language Parser

The latest version of Astera Centerprise includes the Language Parser functionality in the Expression transformation object. It allows users to standardize data by using advanced expressions, such as interpolated string and verbatim, on a certain data set.

Here’s how the Language Parser works in Centerprise:

Interpolated String

Users can parse variables in the source data to create the required output string. An interpolated string uses a dollar$’ notation before the expression syntax, with the variable values or parameters enclosed in curly brackets{}’, which is dynamically updated during the runtime. It takes input from the source data and returns the output corresponding to each record in a new field.

Figure 4: Expression syntax for Interpolated String

Figure 4: Expression syntax for Interpolated String

The result of this expression can be viewed in the AuthorInfo field.

Figure 5: The Interpolated String output in the preview screen

Figure 5: The Interpolated String output in the preview screen

Verbatim

The verbatim string enables users to insert line breaks, tabs, other escape sequences, and file paths without writing escape characters. This improves the output readability and simplifies expression creation. The syntax involves assigning a distinct output field and adding an ‘@’ sign before the expression.

Figure 6: Expression syntax for verbatim

Figure 6: Expression syntax for verbatim

The result of the verbatim string is visible in the Office field.

Figure 7: The Verbatim output in the preview screen

Figure 7: The Verbatim output in the preview screen

Real-Time Error Information

The Expression transformation pinpoints the source of errors in real-time when compiling an expression, enabling error detection and improving debugging. Key errors identified by this new feature include the following, among others:

  • Unexpected token: Incomplete expression
  • Undetermined string lateral: Improperly closed string variable
  • Invalid identifier: Invalid field name

PostgreSQL Repository

One of the primary steps in setting up Astera Centerprise is creating a repository, which stores information regarding job queues, job logs, and schedules. In Centerprise 8.2, users can leverage open source PostgreSQL to create cluster database, in addition to SQL Server.

Figure 8: Configuring PostgreSQL to build a repository

Figure 8: Configuring PostgreSQL to build a repository

ReportMiner Upgrade

Astera Centerprise 8.2 is shipped with an upgraded version of ReportMiner that includes a complete UI overhaul, in addition to data cleansing and Auto-Determine Field Name options. The redesigned UI simplifies navigation and enables data extraction with minimal IT intervention.

Figure 9: New UI of ReportMiner 8.2

Figure 9: New UI of ReportMiner 8.2

Go through this blog to learn about the new features available in ReportMiner 8.2.

To get a flavor of all these features, download the trial version and leverage the power of our end-to-end data integration platform.