Author: Irfan Ahmedirfan-ahmed

Data Integration Enables University to Analyze $3.2 Billion Endowment Fund

In an article just published by Solutions-Review.com, Jay Mishra discusses how Centerprise enabled Vanderbilt University to overcome the challenge of integrating disparate data from multiple sources in order to maximize return and minimize risk for its $3.2 billion endowment trust. […]

Read more

Get Your Free eBook: Data Integration for Business Users

Astera specializes in data integration solutions that can be used by business professionals to perform many tasks with minimal IT supervision, moving projects along faster and freeing up valuable IT resources for more mission-critical work.Ideally, data integration should be done by […]

Read more

Data Integration Key for Credit Unions Moving to New Software

One of our customer success stories recently made headlines in the Credit Union Journal.   Randolph-Brooks Federal Credit Union used Centerprise to migrate its legacy data to a new Fiserv core banking system. With over 400,000 members and assets exceeding […]

Read more

Get Your Data Under Control in 5 Steps

Whitepaper: Get Your Data Under Control in 5 Steps Across every industry vertical and without regard for organization size, there is one fact that remains true: the data deluge is upon us. The much-­‐ballyhooed “Big Data” phenomenon that prognosticators have […]

Read more

Six Reasons Why Hadoop is not an Integration Solution

In August our blog, “Why Proprietary Software Can be More Cost-Effective Than Commercial Open Source,” enlightened readers about the potential high costs of choosing commercial open source (COS) over proprietary software. In this blog we build on that theme by […]

Read more

Dataflows: The Cornerstone of Data Integration Examples 6-20

Example 11. This subflow contains some complex logic to process dates. Most of the Input fields are passed through with no additional processing from Subflow Input to Subflow Output.  The date fields, on the other hand, are processed using a set […]

Read more

Dataflows: The Cornerstone of Data Integration Examples 1-10

  Example 1. Simple dataflow reading source tables using a multi-table query and inserting records to an Oracle database table. The data is transferred ‘as is’ with no additional transformations, using direct mapping between source and destination fields. Example 2. Complex dataflow. […]

Read more

Dataflows – The Cornerstone of Data Integration Part 3

  Part 3 – Managing Dataflow Layout Auto Layout The Auto Layout feature in Centerprise allows you to arrange objects on the dataflow to improve its visual representation. To invoke the Auto Layout feature, click the icon on the Dataflow toolbar, […]

Read more

Dataflows – The Cornerstone of Data Integration Part 2

  Part 2 – Creating a Dataflow To create a new dataflow, go to File -> New -> Dataflow on the main menu. Or expand the New Dataflow dropdown on the main toolbar and select Dataflow from the dropdown menu. […]

Read more

Dataflows – The Cornerstone of Data Integration Part 1

  Part 1 – Introduction to Centerprise Dataflows Because dataflows are the cornerstone of data integration, we’ve organized into a blog series our documentation on Centerprise dataflows. Centerprise Dataflow Designer, with its visual interface, drag-and-drop capabilities, instant preview, and full […]

Read more

VinSolutions/AutoTrader.com Keeps Track of Over a Million Cars With Centerprise Automated ETL

“Every time we brought in a new dealer, there was a lot of development effort that had to be taken into account, whereas with Astera, it’s a lot faster process, and it doesn’t require a developer to be involved every […]

Read more

Using ReportMiner to Extract Business Information From Printed Documents Part 2: Main Region

Last week we talked about how ReportMiner can be used to build an extraction model quickly and easily and demonstrated how to create the header in a report Model. Now that the definition of the Header has been created, the […]

Read more

Using ReportMiner to Extract Business Information from Printed Documents – Part 1: Creating the Header

Information drives today’s businesses and manually transferring printed and written data into electronic formats is no longer a cost-effective option. Astera’s ReportMiner enables users to electronically extract data from printed documents so that it can be integrated into a company’s […]

Read more

Commercial Proprietary Software vs Open Source – Which is Better?

  You can spend your money and buy the house, or you can spend your time and build the house. Either way, you pay for your house. Let’s begin by understanding what is commercial software. In simple words, it is […]

Read more

Data Conversion – Complex Doesn’t Need to be Complicated

Overview Data conversion transforms data from one format to another so that source information can be integrated into a destination database. Data conversion software can extract data from multiple sources and then transform it into the data type required by […]

Read more