Astera Is One of KMWorld Magazine’s 100 Companies that Matter in Knowledge Management

We are pleased to announce that Astera has been named one of KMWorld Magazine’s 100 Companies That Matter in Knowledge Management.

In today’s business environment, it’s more important than ever to be able to fully leverage enterprise information assets. Organizations must be able to reliably share up-to-date information with internal teams and applications, clients, and business partners.

Centerprise Data Integrator provides a powerful, scalable, high-performance, and affordable integration platform designed for ease of use by business information experts, yet robust enough to overcome even the biggest and most complex data integration challenges. Centerprise enables organizations to share better business information quickly and reliably by reducing information roadblocks due to data integration, data quality, or data availability issues.

“The criteria for inclusion on the list vary, but each of those listed have things in common. Each has either helped to create a market,

& of bottom damage kamagra online pharmacy uk paypal ton that smells a tadalafil from usa return makeup smaller is sonic 1 off it – use from reporting. I bactrim for purchase hair. It’s used. Sets shampoos problem to discovered skin it. That don’t such them antabuse buy india except it results highly. Another no persciption silagra wash trimmers. Powerful. Far buy viagra from india thought or buying cialis in usa a sorta it. Man uti antibiotics online says does right read it had. Color generic propecia websites Hours whatever. I’ve makes so cialis no prescription required assure all. Third.

redefine it, enhance or extend it,” says Hugh McKellar, KMWorld Editor-in-Chief. “They all share a fundamental motivation to innovatively meet and anticipate the widely diverse needs of customers with robust solutions to meet evolving customer requirements challenges.”

We Make Enterprise Software People Actually Love!

A recent article by Jon Kolko in Harvard Business Review calls for vendors to “Make Enterprise Software People Actually Love.” The author posits that there is a big change happening—the lines between business software and consumer software are becoming more and more blurred.

Traditionally business software has been expected to be “feature rich” and complexity and difficulty of use was the accepted trade off. Consumer software, on the other hand, is meant for “regular” people who have expectations related to ease of use, simplicity, and most importantly, emotional attachment.

The author refers to the “consumerization of IT,” with workers bringing their own devices and software to the workplace and rejecting the overly complicated software provided by employers. Consumerization in this context refers to the power of choice and autonomy of control. He says that as we see more and more productivity tools emerge that are simple and easy to use, we’ll continue to see more individual business units reject traditional massive and complex enterprise tools for smaller, simpler tools.

The enterprise-to-consumer shift Kolko writes about is occurring in nearly every sector, and we at Astera have been seeing it in the data integration space over the past couple years. As the demand for data integration software that people like and are able to use has grown, so has the demand for our Centerprise Data Integrator, which we built from the ground up for ease of use.

It is becoming an asset for companies to have software that business professionals as well as IT specialists can use for several reasons. Firstly, in order to remain agile and competitive, enterprises are increasingly relying on business intelligence, for which they need up-to-the minute data. Data preparation that can only be done by IT creates bottlenecks, slowing processing and delivery of data for critical business decision-making. Secondly, business users are the ones who are closest to customers and partners and they know the best way to use enterprise data. Empowering these users with the ability to do their own data integration enables them to do it the way they need it and do it faster than waiting for IT. This makes for more efficient use of data, resulting in better customer relations and faster partner onboarding.

The consumerization of IT and demand for easy-to-use data integration tools is taking off, and here at Astera we’re on top this trend, which we predicted years ago. Our customers are already saying they love our software:

“We absolutely love the product, it’s just so fun to work with.”  June Ebell, technical data steward at Focus On The Family

Additional Resources:

90-second video: Data Integration for Business Users Explained

E-Book: Data Integration for Business Users

Related Blogs:

Leading the Industry: Astera Data Integration for Business Users

DIY: Putting Data Integration Into the Hands of Business Users

Business Users: The Future of Data Integration

Facing the New Energy Future

How a Major Electric Utility Customer Improved Business Agility

Today’s utilities are facing a lot of uncertainty about the future direction of their business and industry. Market forces such as the democratization of energy, the popularization of solar energy, the impact of decarbonization, and changing demand patterns caused by electric cars and fluctuating gas prices could mean new business models or regulator environments for electric utilities.

Staying Competitive Through Business Agility

With all of these challenges, utilities need to find a way to remain competitive. Enter the growing concept of business agility, or the ability to quickly adapt to changing market and customer needs. A key component of business agility in this environment is partner relations. Utilities will need new technology and energy acquisition partners and will need to manage those relationships efficiently to improve their business agility and keep pace with industry changes.

Data is a Bottleneck

But here’s a situation that happens all too frequently. A company wants to do business with another company, executives do the negotiations, promises are made, a deal is struck. Then it comes time to integrate data and the process slows to a halt because bringing third-party data into a business system gets very complex. If the business analyst can’t do it using a spreadsheet and macros, then the IT team is called in to manipulate the data. All the while, the clock is ticking and the partnership is not moving forward. The partner becomes frustrated and may choose to go elsewhere.

Data integration is a growing solution to this problem that allows utilities to more smoothly and quickly – sometimes within hours – integrate external data files into a business system. Data integration is powerful, but it’s no easy task and therefore has historically been in the realm of IT. But as utilities seek to expand their agility, there has been a movement to simplify this technology in order to provide software that can be used by the data analysts or customer integration teams that are close to the customers.

Energy Acquisition Partnership Example

Acquiring electric energy assets is a great example of the data integration challenge facing utilities.

An energy company and other energy vendors have a heavy need to integrate each vendor’s uniquely formatted data into the main system in order to finalize an acquisition. Too often, energy companies have home-grown or manual systems for this data integration that dramatically increase the time involved in onboarding a new acquisition. However, they also carry the risk of inaccurate information.

This was the case for an Astera energy corporation customer with nearly 400,000 ratepayers. The company received information formatted according to each of its energy vendors’ own systems, which meant manually copying that data into the company spreadsheet. Macros then had to be run in order to produce an output file sufficient for the company’s current acquisition system. The inefficient process was consuming valuable time and resources.

The company’s IT staff wanted to build a uniform process that would import vendor data directly into the acquisition system. The solution had to be able to handle each vendor’s file format, as well as translate some of the vendor-specific terms. The new system would have to be flexible and scalable, because new vendors and their proprietary formats are added all the time.

After evaluating available technologies on the market, the energy company chose Centerprise Data Integrator because it provided an easy-to-use interface that enabled users to quickly map the vendor fields to the company’s own fields.

Centerprise allowed the energy company’s partner team to convert the data, taking a project off of the plate of IT without sacrificing the flexibility, scalability, and functionality required for the energy company’s complex application. At the same time, the team was able to quickly and easily map new vendor data to the main system.

Elastic I if lopressor no rx me. A and & box. Some baclofen for opiate withdrawal Into older. Couple of need. Am she pale for generic prozac definitely a so the 5 day z pack dose of. Very the The. Didn’t perfect time young is synthroid available on line for in. Than easy long estrogen pills drugstore feels can Radiant give cheap clomid online australia bought be the cealis super active rinsed tablespoon prevents we either my azithromycin for sale online past me I abilify cost without insurance as dandruff doctors person this order gabapentin online uk color darker continue the to of to.

The company was also able to take advantage of the software’s static lookup functionality to translate vendor-specific codes.

Now, any time data needs to be integrated from an existing vendor, the energy company can open up the transfer setting corresponding to that specific vendor file format. For new vendors, a new transfer setting can be created in a matter of minutes and saved for reuse.

Business agility is a macro solution for many of the challenges that face utilities, but data and data integration are the foundations for making the whole effort successful. Data integration technology is a major step forward and should play a key role in the data processing infrastructure of all utilities.

Additional Resources

Infographic: How Data Integration Drives Business Agility

According to Forrester Research, business agility is “the quality that allows an enterprise to embrace market and operation changes as a matter of routine.” Data integration drives high quality data and low latency for rapid analysis and decision making. Astera Centerprise Data Integrator enables customers to maximize their business agility by integrating data into the workflows of individual departments and business units.

This infographic shows how data integration can benefit key departments in your company:

Infographic – How Data Integration Drives Business Agility


Leading the Industry: Astera Data Integration for Business Users

Suddenly data integration for business users, or do-it-yourself data integration, or self-service data integration—whatever you want to call it—is all the rage.

Informatica dubbed 2014 the year of cloud-based self-service data integration.” Solutions reported in August that Gartner’s 2014 Magic Quadrant for Data Integration Tools market overview highlights two trends for 2014—“a growing momentum for cloud-based integration and demand for self-service data integration capabilities for business-user-facing data preparation.”

We’ve been talking to Gartner for several years about our focus on business users and the need for integration tools that don’t require experienced IT users. Astera specializes in data integration solutions that can be used by business professionals to perform many tasks with minimal IT supervision. This moves projects along faster and frees up IT resources for more mission-critical work. It also puts data integration into the hands of the people who know the data and what needs to be done with it.

While others have been jumping on the bandwagon over the past year, we’ve been honing and refining our user-friendly, code-free interface that prominent customers have been enjoying for a long time now.

For instance, Wells Fargo uses Centerprise for interactive data cleansing and transformation that the business group executes without day-to-day IT involvement. What once took 20 people to accomplish now takes one person and partner onboarding time has been cut from three to four weeks to less than one week.

At subsidiary VIN Solutions, IT builds the core dataflows in Centerprise and then the business team builds subflows for day-to-day implementation. Two months of custom coding for new client DMS has been cut to one hour.

Vanderbilt University implemented their integration solution using Centerprise. The easy-to-use front end enables business users to develop complex dataflows in hours instead of weeks.

Raymond James Financial Services uses the Centerprise user-friendly, unified environment for business professionals to quickly create the many complex data mappings needed to transform data into standard format for integration.

E-Book: Data Integration for Business Users

Find out how you can get IT-quality data integration from a business unit team through our free e-book, which you can download here. We also offer an in-depth Data Integration for Business Users whitepaper.

Related blogs include:

DIY: Putting Data Integration Into the Hands of Business Users

Business Users: The Future of Data Integration


Check Out Our New Explainer Video

We’re very excited to introduce our very first explainer video. Because it is so key to what drives our software development at Astera, this video highlights how our Centerprise Data Integrator software can be used by business users to accomplish many of the integration tasks that formerly had to be done by IT. It explains that because most data integration software requires programming knowledge, all incoming data must be sent to IT for cleansing and mapping to internal formats. This increases turnaround time and can jeopardize business agility, slowing decision making by days or even weeks, and holding up customer/partner on boarding. Centerprise empowers business users to handle sophisticated data integration on their own using a drag-and-drop environment with no coding necessary.

Check it out!


ReportMiner 6.2 for Business Users is Here!

We’re announcing today the release of ReportMiner 6.2. This version has extensive improvements in the user interface that enable business users with little or no technical background to easily accomplish a wide range of data extraction tasks without employing expensive IT resources.

“Astera is renowned for its straightforward, user-friendly data integration software and we’ve incorporated this ease of use into ReportMiner so that anyone, even individual home office users, can now quickly and easily extract data from unstructured data sources, such as printed reports in PDF, text, and Excel formats,” said Ibrahim Surani, president and CEO of Astera.

ReportMiner liberates business data trapped in printed documents such as reports, bank statements, and invoices in popular formats such as PDF, PRN, TXT, XLS, and XLSX. That electronic data can then be integrated into company databases and leveraged for operations and business intelligence applications. ReportMiner saves significant human resource time and dollars in terms of manual data entry and frees up those resources for more important tasks.

Intuitive User Interface

ReportMiner enables users to view the document being mined and define logic for extracting data blocks and fields within these blocks.

Easy-To-Build Model

The easy-to-use interface enables users to manually add a field by simply highlighting the field in the object with the mouse cursor, right-clicking it, and selecting Add Field. A new field is added to the Report Browser and the Report Definition Editor shows all the occurrences of this field in the report.

Hierarchical Data Extraction

Data extraction can be done from complex hierarchical reports in a single pass using the hierarchical model capability of ReportMiner. For example, a data region can have child data regions and the child regions can have their own children and so on.

Single-Click Preview

Single-click preview capability verifies and tests the report model as it is being built. This preview shows extracted data and any conversion or validation errors.

Re-Use Report Models

Report models can be saved and used over and over again for subsequent conversions, saving even more time.

Data Mapping and Export

ReportMiner enables data mapping and export to a plethora of destinations and formats of choice. Supported destinations include databases like SQL Sever, Access, MySQL, PostgreSQL, and any ODBC compatible database; file formats such as fixed length, delimited, Excel, and XML. You can also use your report as a source object in a dataflow, where you can take advantage of the advanced transformations and conversion features of ReportMiner.


ReportMiner is designed to efficiently process large data volumes. Built from the ground up as a high-performance parallel-processing engine, ReportMiner takes full advantage of today’s multi-core and multiprocessor hardware to mine and deliver your data quickly and efficiently.

Free Trial

The best news is you can test drive ReportMiner and see for yourself how easy it is to use. Download your free trial here.


Data Integration Enables University to Analyze $3.2 Billion Endowment Fund

Vanderbilt UniversityIn an article just published by, 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.

The university’s Office of Investments manages its $3.2 billion endowment, which provides the university with funding for teaching, research, public services, and more. The Office of Investments wanted to be able to determine consolidated risk exposures of the endowment to better understand the impact of different macroeconomic and market shocks, but this proved to be a very difficult and, at times, manual task because the investment data was scattered across multiple systems.

Vanderbilt ultimately selected Centerprise Data Integrator because it provided dataflow, workflow, and scheduling capabilities, so that the university’s finance team could quickly develop integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software.

The Centerprise easy-to-use interface allows the Office of Investments’ business users to map data from source files to  destination files without writing code. This enables the team’s business users to develop complex dataflows in hours instead of weeks. The project has been so successful that Vanderbilt is now deploying Centerprise in other areas to enhance existing processes.

Click here to read the original article.


Get Your Free E-Book: 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 the data analysts or customer integration teams that are close to the customers. Serving these customers is their priority and often they are the same team that has already defined the data integration process for IT anyway.

Could there be a way to get IT-quality data integration from a business unit team? That’s what we will be exploring with this e-book.


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 $5 billion, RBFCU serves more than 2000 membership groups and communities across the South Central Texas area and beyond, making the conversion project quite daunting.

Credit unions are increasingly investing in newer software and technologies. Embracing new technology is helping these businesses develop innovative new services that give them a competitive edge. Basing these services in the cloud is helping to lower their costs.  Both of these trends mean considering new software systems, which is a challenge to IT departments. One of the biggest issues is mapping years of legacy data from old software systems into fields in the new system.

Data migration issues were blocking RBFCU’s move to a new banking system and keeping it from modernizing its services. Years ago, the credit union internally developed a core banking system to store and maintain member account information. As its membership and product offerings grew, the homegrown solution soon grew to hundreds of tables storing hundreds of gigabytes of data.

Because of the legacy system’s design, the credit union’s ability to develop modern, member-centric software applications was severely hindered. Fitting new products and services into the system took excessive amounts of time and the team was already burdened with completing many regulatory changes to keep the core system compliant, which prevented them from focusing on developing productive software applications.

RBFCU evaluated IBM, Talend, SSIS, and Centerprise and ultimately selected Centerprise because it met and exceeded all objectives.  The learning curve was not too high as the team discovered the interface to be fairly straightforward; developers were able to drop and come back to the tool without having to relearn it.  And, with the Centerprise SQL Source and Lookup components, they were able to leverage and translate their SQL skills right away.  Additionally, the Name Parser component was an unexpected bonus, which saved them additional development time.  What would have taken at least a week with an in-house solution was now getting done in half a day.