What’s New in Centerprise 7.5

New additions, enhanced performance, and improved usability – Centerprise 7.5 is better than ever!

Centerprise Data Integrator is an end-to-end ETL and data integration solution that empowers business users to perform complex data integration tasks without relying on IT. With the code-free, drag-and-drop IDE of Centerprise, we aim to flatten the learning curve for business users and make self-service data integration possible for them.

Here is everything that we’ve improved and added in Centerprise 7.5 to make it even better and a feature-rich data integration solution.

Improved server resiliency

We have greatly improved the server resiliency in Centerprise 7.5. This will ensure trouble-free server operations, better and quick recovery in the case of a database outage event, and overall improvement in the performance.

Here are some of the benefits that the users will get with this improvement:

  • Astera integration server will no longer go in a permanent state of error in case of a database outage event and will automatically recover as soon as the connection is restored.
  • Server connection will be automatically established when the connection to the repository database is available and no manual restarts will be required.
  • Activity and error tracking are greatly improved in the new release. The server writes database connection issues in the Windows event log and includes a link to the error file for easier troubleshooting.

New transformations added to the library

The transformation library in Centerprise Data Integrator is extensive and encompasses a wide range of data integration scenarios. However, we strive on making the ETL and data integration process easier for our users and thus we have included new transformations in Centerprise 7.5. These new additions are:

Switch transformation

Switch data representation to get accurate business insights

There are more than one ways of representing the same information. It is important to have the information presented in the correct representation to drive accurate business insights. Switch transformation is used to replace the data in the source file with any other representation that is more relevant to the present business case.

Learn more about how Switch transformation works in Centerprise and how it can be applied in a business scenario.

Reconcile transformation

Reconcile information for self-service data analysis

Reconcile transformation helps in reconciling information in the source data. Application of the transformation can be seen in a wide range of business use cases where merely storing data is not sufficient and monitoring the changes in data over time is essential to drive critical business decisions.

Some of the benefits of the Reconcile transformation are:

  • Can be applied to flat or hierarchical source data.
  • The transformation can be applied to inner nodes as well when the source data is in a hierarchical format.
  • Business users can perform data analysis by comparing old and new values for specific fields in the source data.
  • Provides options to view data in multiple layouts so users can choose the layout which is most in line with business requirements.

Read more about how Reconcile transformation works in Centerprise here.

Merge transformation

Merge data from disparate sources for a consolidated and unified view

As the data collection avenues are increasing, it has become a common practice for businesses to integrate data from multiple disparate sources. In some cases, the same data is contained in different sources and businesses face the need to merge the fragmented data for a consolidated view. Merge transformation in Centerprise helps in achieving this task.

What’s Next?

We have a number of new features lined up for the upcoming releases and we are excited to share the updates with you. Subscribe to our blog or join our community of data professionals to stay informed. To see Centerprise in action, schedule a discovery call with us today!

Switch Transformation in Centerprise 7.5

Overview

Switch transformation is among the newly introduced transformations that are included in Centerprise 7.5 version. It is a basic, yet an extremely useful transformation and has applications in a wide range of business use cases.

This transformation can be applied when there is a need to replace information stored in the source data with some other relevant information. Information is switched (or replaced) based on some preassigned rules.

Switch Transformation Explained with a Business Use Case

An organization maintains a database for their employees. Employee_Info table in that database contains information such as employee’s name, department, salary and employee ID.

Figure 1: Source file and data preview before the switch transformation is applied

For the ease of maintenance, the organization assigned a specific number to each department (Marketing, Sales, Finance etc.) and that information is recorded in the Department field as shown in figure 1.

Using the Switch transformation, the numeric values stored in the Department field can be easily replaced with their corresponding department names.

Basic Mode in Switch Transformation

The basic mode in Switch transformation works like a List Lookup. In this example, we want to replace the numeric information stored in the Department field with their actual corresponding departments.

Figure 2: Switch Transformation (Top: Basic Mode – Bottom: Enhanced Mode)

Drag-and-drop the transformation from the toolbox to the designer and map the required fields. Here we are mapping EmployeeID, Department, and Salary fields from the source file to the Switch transformation (BasicMode_Switch).

In the properties window of the transformation, select the field that you want to perform the switch operation on, and specify the criteria in Case Value, based on which Centerprise will look for the information and replace it with the given information in the corresponding Output Value.

Figure 3: Switch transformation properties window (Basic mode)

Now if you preview the output or write the transformed data to any destination, you will see that the numbers in the Department field are replaced with the information that is based on the rules assigned in the properties window shown in figure 3. In a case where Centerprise won’t find any matching case value, it will automatically assign the specified default output value, which is Admin in this example.

Figure 4: Data preview after the Switch transformation is applied

Enhanced Mode in Switch Transformation

The Enhanced mode in the Switch transformation provides more flexibility to the feature because it enables users to set lookup criteria by writing expressions. Figure 5 shows the properties window of the enhanced mode in Switch transformation.

Figure 5: Switch transformation properties window (Enhanced Mode)

Suppose our fictitious organization has set criteria for issuing credit cards. Employees whose salary is less than $3,500 are not eligible for the credit card. Employees with a salary between $3,500 and $5,000 are eligible for the Silver card. Other similar assignments can be seen in the Case Expression column in figure 5.

The organization has the data about employee’s salaries and the ranges for the issuance of credit cards. In this case, employee’s salary, which is the information that is stored in the database, is not relevant to the concerned department. What they’re looking for is to identify which employee is eligible for which perk. This can easily be achieved by matching the salary ranges defined in the Case Expression and switching it with the corresponding information about the credit cards specified in the Output Expression.

Figure 6 shows the output preview for the enhanced mode case in the Switch transformation.

Figure 6: Output preview of switch transformation in the enhanced mode

Benefits of the Switch Transformation

Switch transformation gives users more control over data as it enables them to transform the given information into something more relevant, which is best suited to the given business scenario. When applied to any data set, switch transformation matches source data for the criteria specified by the user, and replaces the information with the desired output (also specified in the layout) wherever the criteria is met.

Server Resiliency Improved in Centerprise 7.5

We are releasing Centerprise Data Integrator 7.5 very soon, and as with every new release, our focus is to improve the product experience for our customers. We have added new features and have made improvements to the existing ones in the upcoming build.

One of the key changes we have made in the 7.5 version is greatly improving the server resilience. This will ensure trouble-free server operations, even when connection issues occur between Astera server and the MSSQL server hosting the repository databases. Enhanced server resilience will not only improve the overall performance of Centerprise, but will also prove to be significantly beneficial in the scenarios where 24/7 operation with high uptime is required, which is the case with most of our enterprise customers.

Key Benefits of Improved Server Resilience

With improved server resilience, users will get the following benefits:

Better and quick recovery of the server

With improved server resilience, Astera server will no longer enter a permanent error state after a database outage event. Instead, it will recover as soon as the connection is restored, allowing the customer to continue with the normal operations without any downtime. The server can now survive most repository database outages without any user action required.

Auto-recovery mode – no manual restarts required

Manually restarting the server will be no longer necessary in case of lost connectivity. The server will recover automatically. If the server starts up when a connection to the repository database is not available, the server will enter a paused state waiting for the connection. When the connectivity is restored, the server will enter its normal operational state without the need for manually restarting it.

Improved performance

Improved server resilience means improved performance. If the server is running the flows and an outage event occurs, the flows will not be terminated, and instead paused waiting on connection. This means that the server will be able to complete most flows successfully even in the presence of multiple random network and/or database connection issues.

Activity/Error tracking

Logging in general, and logging of database connection issues in particular, have been greatly improved in the new release. Moreover, the server writes database connection issues in the Windows event log and includes a link to the Error file for easier troubleshooting. An entry is also added to trace the server log when the connection is restored.