Category Archives: Astera News and Views

Big Data Toronto 2018: Post-Event Highlights

Team Astera participated in Big Data Toronto 2018 as an exhibitor and had a truly great experience networking with data scientists, practitioners, and thought leaders from across North America and beyond. We took the opportunity to introduce our end-to-end, agile data warehouse solution, DWAccelerator, and received a great response from the attendees.

Event Overview

Going strong in its third year, Big Data Toronto is among the most acclaimed big data and analytics conferences & expos in Canada. Over 4,000 innovators, 60+ exhibiting brands, and 100+ speakers gathered under one roof to embark on an educational journey and exchange technical insights, while providing an outlook on future trends of technology and best practices related to AI and data science.

The conference, held in Metro Toronto Convention Centre, was a two-day event, and covered key topics, including digital transformation, data governance, data management, predictive analytics, advanced machine learning, cyber security and privacy, and more.

Highlights of the Event

Big Data Toronto 2018 has been a thought-provoking and insightful journey for our team. Here is what we learned from the conference:

Agile Data Warehousing Practices

Data warehousing, as a field, stays highly relevant for businesses in the big data era, albeit the expectations have changed significantly over time. Agility in design and development of warehouses has become a key requirement. Businesses are diligently seeking solutions that can accelerate core data warehousing functions, such as data integration, analysis, and cleansing for business intelligence, among others.

Intelligent Data Extraction

Businesses are increasingly taking interest in agile data warehousing solutions that offer effective data extraction from complex structured and unstructured sources, as well as traditional sources. They need accurate, intelligible results quickly to acquire analytical reports through business intelligence tools, allowing them to conform to the changing market dynamics, as well as for making sound decisions for future endeavors.

DWAccelerator – The Solution to Major Data Warehousing Problems

Massive setup costs, time-consuming processes, and lack of agility and flexibility are some of the key obstacles met during BI project implementation. DWAccelerator can very well be the answer to all these issues. DWA is an all-round solution that instills agility and automation in data warehouse designing and development without having the user write a single line of code.

Our COO, Jay Mishra, conducted a session on “Accelerating your Data Warehouse Project” and shed light on problems and ways for businesses to speed up setting up a data warehouse. He presented DWAccelerator and showed that while a data warehouse, using traditional techniques, takes anywhere from a few weeks to several months to build, it can be done in under an hour with our automated solution. Some of the highlighting features of DWAccelerator, such as data models based mapping, automatic field matching, flow generation, and the concept of virtual data models, were well received.

We Met Prospective Partners and Clients

The innovative features and powerful data warehousing capabilities of DWAccelerator gathered much attention from the attendees. We talked to many data professionals and showcased how our product can automate the entire data warehousing process and cut down the costs and time required. This generated a lot of interest in our product, inspiring several new partners and prospective clients to join hands with Astera.

Overall, Big Data Toronto 2018 offered a plethora of insights and concepts that are likely to pave way for future technologies and trends. In addition, the Canada’s #1 big data and AI conference proved to be a great opportunity for us to meet new clients and partners and provide exposure to the latest addition to our product line, DWAccelerator.

Automate Partner Data Exchange and Integration through Astera’s Customer Portal

Effective business intelligence demands proper data collection and integration processes. Modern businesses receive data in different formats from a variety of communication protocols, when efficient collaboration and tracking of data exchanges are more important than ever before.

Partner Data Exchange and Integration Automation

Partner Data Exchange – Centerprise Data Integration Software

As data increases, the maintenance and management of multiple files from disparate sources takes its toll on IT teams. File based partner data exchanges need to be fast, reliable, and secure for transfers, especially on large-scale operations. Manual data entry and file exchange over channels like email aren’t sufficient anymore. Businesses need a centralized platform where customers, partners, suppliers, and employees can upload data files, ensure compliance, and track file status.

Enter the new Astera Cloud Customer Portal.

Key features include:

Centralized Uploading

Partners upload data files directly on the portal URL using their unique login credentials. Validation and cleansing take place automatically on the backend Centerprise server using custom integration flows. A response file is generated at the end for both the admin and users.

File Tracking

The Customer Portal comes with inherent file tracking: all involved remain up-to-date on file statuses in real-time via the Dashboard. For unsuccessful uploads, the response file contains error codes and explanations. Status emails can also be configured for all types of accounts. This ensures all necessary files are uploaded correctly after data validation, allowing the final workflow to run as scheduled.


Secure Sockets Layer (SSL) and file encryption are supported on the Customer Portal. Uploaded encrypted files are automatically decrypted, processed, and then re-encrypted by Centerprise to be sent back.


The Customer Portal is built to handle unlimited data volume and borrows on Centerprise’s powerful scalability. Cloud servers can also be added for reliable load balancing.

White Label Capability

Astera Cloud’s Customer Portal is customizable, with the ability to use your company logo and domain name. Get all the functionality of Centerprise while maintaining brand cohesion.

For a live demo and information on pricing for our partner data exchange and integration solution, call us at +1 888-772-7837 or email us at

ReportMiner Has Been Named a 2015 Trend-Setting Product by KMWorld Magazine

KM World Trend Setting Product 2015We are excited to share with our blog readers that our industry-leading ReportMiner data extraction software has been named a 2015 Trend-Setting Product by KMWorld Magazine!

KMWorld Editor-in-Chief Hugh McKellar commented that, “In each and every case, the thoughtfulness and elegance of the software certainly warrants deep examination. Depending on customer needs, the products on the list can dramatically boost organizational performance. The products identified fulfill the ultimate goal of knowledge management—delivering the right information to the right people at the right time.”

The panel, which consists of editorial colleagues, market and technology analysts, KM theoreticians, practitioners, customers and a select few savvy users (in a variety of disciplines), reviewed more than 200 vendors, whose combined product lineups include more than 1,000 separate offerings.

ReportMiner’s user-friendly interface enables business users with little or no technical background to easily accomplish a wide range of data extraction tasks without employing expensive IT resources. Smart features such as automated name and address parsing and auto creation of data extraction patternsautomate many time-consuming manual tasks, saving time and increasing data quality. You can find out more at

We Have a Winner!

contest winnerWe just finished our second campaign to post customer reviews on a software reviews portal and we are excited to announce that Phil Nacamuli of Leximantix has won the iPad drawing. We had a great response to this campaign and want to thank all of our customers who took the time to post a review of Centerprise or ReportMiner.

You can access all of our reviews on our customer testimonial page. Here are some that stood out for us in this latest campaign:

Prasad Sunkara of Vish Group

“Centerprise at its best!”

Centerprise at its best! Easy for business users. We were able to train new employees and get them to speed within a week. Using Centerprise as an ETL tool is working out great. Especially working with uncommon data sources! The tool is easy to use, very affordable to own and returns are very high, including increased speed of delivery of data, business user-driven data delivery and rapid prototyping.

Dawn Bauer of Farmers Mutual Hail Insurance

“Fast and Simple. All-in-one package”

Centerprise is perfect for dumping data from an ODS system into a data warehouse for reporting. It is fast, easy and simple to use. You can have a dataflow up and running in mere minutes compared to some other tools on the market.

Don Smith of Software Solutions

“WOW Why did we wait soooo long?”

Centerprise allows us to create a reusable template to standardize the information that we use to validate conversions. Standardizing the reporting data from two systems is an awesome strength that can be developed out of Centerprise. We have seen that the use of this package saved us 2 hours per conversion but now since the templates are already developed it is saving us more. This reduces our lead time for conversions, and increases our efficiencies as a conversion team.

Mario Ferrer of Achievers

 “Astera Centerprise rules!”

I love Centerprise and I believe it has a lot of potential. It’s incredibly easy to use. People with no previous ETL experience can start building simple mappings very quickly. It’s incredibly easy to install and maintain. After I first installed Centerprise, I was able to start working in just a few minutes. I am particularly impressed with how much Centerprise simplifies transformations that require more work in other ETL tools. The perfect example is the SCD transformation, which handles all the logic in an Slowly Changing Dimension. Even with a market leader like Informatica, the SCD logic has to be manually built. With Centerprise this can be built in just a few minutes, and it impacts every mapping.

Data Integration: Helping Startups Operate Efficiently and Gain the Competitive Advantage

“Startups are keeping head counts low, and even eliminating management positions, by replacing them with a surprising substitute for leaders and decision-makers: data.”

This is the subject of an article in The Wall Street Journal that ran Sunday, April 19.  “Every time people come to me and ask for new bodies it turns out so much of that can be answered by asking the right questions of our data and getting that in front of the decision makers,” says James Reinhart, CEO of online secondhand clothing store thredUP.

The same or similar stories were told to the author of the article by dozens of other startups. In the past, companies operated by giving managers control over data and those who actually needed the data to make day-to-day decisions had to get in line and wait for the manager to give it to them. Even just a few years ago, the author points out, databases were massively expensive and business intelligence software cost millions of dollars and could take months to install. So it made sense to limit access to managers.

This is not the case today. Thanks to user-friendly, cost-effective data integration software, business users no longer need a manager, or even IT, to hand them the information they need. They can get it themselves, when and where they need it, and make decisions much more quickly and accurately.

It isn’t news anymore that businesses are collecting terabytes of data to analyze and use as a competitive advantage. Now, with affordable software that doesn’t require an experienced programmer to extract meaningful data, every employee has the tools to gather information and make decisions.

The new role of business users in the manipulation and analysis of data doesn’t mean that IT isn’t needed any more. Now data scientists can focus on what they are really good at—making sure the software is working correctly and integrating with other company systems, writing code for customization, and ensuring that the data is clean.

Affordable, intuitive data integration software like our Centerprise Data Integrator is helping to tame the data revolution and ensure that startups have the best competitive advantages possible.

Congrats to the Winner of Our Customer Reference Campaign

We recently ran a campaign to generate updated customer testimonials for our website and a partner portal. The response was amazing and we are fortunate to have such great customers. We want to thank all of our customers who took the time to post a review of Centerprise or ReportMiner on our partner portal and to congratulate Darius Grant of Alcatel Lucent, the winner of our iPad drawing. As a token of appreciation, we sent each customer who posted a review an Amazon gift card. We’ll be running a new campaign for a different partner portal in the near future, so if you missed the fun and the chance to win an iPad this time, keep an eye out in your email for information on the next one.

You can access all of our reviews on our customer testimonial page. We wanted to share some of the best ones here:

Financial Services

Centerprise has been the essential ETL tool for the past 5 years within our data mapping and conversion teams. It has allowed the MIS function to be centered back on the user in a controlled manner without a deep technical aptitude. The interfaces are easy to use and the product remains effective for our data needs with up to date features.

Vish Group

Surprisingly affordable compared to other ETL tools. It is a very easy to use product and easy to learn. Further I am surprised with their product support. I am planning to use Centerprise Data Integrator for my future projects.


Robust Data Management/Transformation tool. Centerprise makes data transformation easy with it’s well equipped toolbox and easy customization.

Software Solutions

Novice User. Within the first two weeks we were able to use Centerprise in four different conversion processes and saved around 10 man hours. That means in 10 days we were able to perform 11 days worth of work. Our biggest problem is that work gets in the way of us exploring even more ways of benefiting from using Centerprise.

The United Methodist Church

We were looking for a product to help us gather data from 50 entities on a variety of platforms, and to provide them with the tools necessary to send the data. Centerprise has enabled us to successfully synchronize the data on an automated scheduled basis. The beauty of Centerprise is its’ flexibility in being able to standardized the data, and handle the entire process from collection, through cleaning and updating, to publishing.

K12 Systems

Centerprise Data Integrator is overall a very useful tool for data integration from legacy systems to the new. Lightweight, easy to use, vast functionality to transform data, logical work flows are re-usable and save time, flexible expressions are very useful to logically transform data, quick support.  Outstanding features and flexibility for many ETL situations. It is easy product to learn and the user interface provides excellent visibility at all stages of the ETL. Overall the product is an great value for the functionality, ease of use and customer support.

VIN Solutions

Great ETL tool, with excellent support. We have been using Centerprise for three years now and it is used throughout our integration department for daily and historical imports and exports. Extremely easy to use. We have handed off import mapping to non-technical people without issues. The product has a variety of useful and important features, and has bee able to handle most everything we have thrown at it. Flexible and extensible. Great support. The team at Astera responds quickly to our questions and is prompt in addressing issues. This has been a great product for simplifying the maze of thousands of different imports we must handle on a daily basis.


ReportMiner is a great concept, easy to use. This is a great tool. The flexibility it offers is amazing, and the customer service whenever I’ve had an issue has been exemplary.


Excellent tool. ReportMiner is a very helpful tool, which makes our jobs much easier. We definitely recommend it!

Exciting New Features in ReportMiner 6.4 Revealed!

We’re launching a major new upgrade of ReportMiner that makes it the most intelligent and user-friendly data mining tool on the market.

ReportMiner enthusiasts and anyone interested in data mining is invited for a sneak peek in a complimentary half-hour New Features in ReportMiner 6.4 Revealed webinar on Wednesday, March 25, 2015 from 11:00 to 11:30 a.m. PDT.

In this webinar we’ll demonstrate exciting new features and functionalities that automate many tasks, saving you time and increasing your data quality. We’ll even be asking for your feedback on the value of these features for you.

Highlights include:

  • Auto creation of data regions
  • Auto parsing of names
  • Auto parsing of addresses
  • Auto creation of fields

Click the button below to register. We hope you can join us!

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