Category Archives: Uncategorized

Business Intelligence Tools and Centerprise

Astera Software’s Centerprise Data Integrator is an easy-to-use and robust data integration tool which can be used for ETL tasks, data quality and profiling. Centerprise seamlessly integrates with various data visualization and reporting tools to create a full-stack Business Intelligence process.

data-warehouseing-img

What is BI Software?

BI software is typically designed to analyze, transform and prepare data for reporting. BI tools use data which has been previously stored and which may or may not be stored in a data warehouse/data mart. BI tools enable users to transform raw data into legible information that enables businesses to make better decisions, which in turn allows for growth and increased revenue.

Centerprise is a complete data integration solution which can be used as a standalone product or can be integrated with other BI tools such as prediction analysis and data visualization tools to achieve a complete data mining and analytics process.

Centerprise provides a scalable, powerful, robust platform which helps in many processes, including: data extraction, data scrubbing, data warehousing, and data migration.

Some of the benefits of Centerprise include:

  • Support for complex hierarchical data
  • Easy to use graphical interface
  • Well-suited for business as well as technical users
  • High-performance and scalable
  • Built-in extensive set of data transformation features
  • Data profiling

    If you’re interested in seeing Astera Software products in action, check out our monthly webinar series! You can find out more on the Astera Software Events page.

Build vs. Buy: How it applies to Enterprise Software

Nowadays, enterprise software is used almost everywhere and at different levels within organizations. It is the lifeblood of most IT departments. One dilemma that tech company leaders face is whether to build a business solution (i.e. custom software) from scratch or to buy commercial, off-the-shelf (COTS) products and mold them according to business requirements.

Some key points when deciding whether to buy or build software are:

  1. The core business requirements, the scope of the problem in question, and the how complex the solution should be in order to fit the business needs and size
  2. Available resources and skills in terms of people, software, hardware, tools, etc. capable of building, maintaining, and supporting the business solution
  3. The amount of time required to develop the solution in-house

Companies that decide to build their own solution tend to overlook issues and expenses, such as:

  1. Replacing existing technology, adding features and functionality to a legacy system is extremely tough and a complete reengineering and rebuilding of business solutions may be needed
  2. A learning curve always comes with building a new software or recruiting additional people with specific skills to build in-house solutions
  3. Higher costs and potentially longer implementation compared to integrating COTS products

One of the biggest software building failure stories is the Bank of America’s MasterNet case study. According to “The Incremental Commitment Spiral Model: Principles and Practices for Successful Systems and Software” by Barry Boehm, Jo Ann Lane, Supannika Koolmanojwong, and Richard Turner:

“In the 1950s and 1960s, Bank of America (BofA) was the leading pioneer in banking automation with its electronic check processing capability. Subsequent BofA leaders had other interests, allowing BofA’s banking automation capabilities to degrade over time. In 1981, BofA’s new president, Sam Armacost, had an agenda to regain its automation leadership by “leapfrogging into the 1990s.” After an in-house effort that spent $6 million and failed to develop a workable trust management system, Armacost appointed a new executive vice president of the trust management department, Clyde Claus, with the charge of either modernizing the department or discontinuing it.

“…[However,] system problems continued…[and] clients began dropping off, with BofA’s base dwindling from 800 to 700 accounts and from $38 billion to $34 billion in institutional assets.… Eventually, in May 1988, BofA transferred its whole trust business to other banks, after an overall expenditure of $80 million and more than four years of project effort. The previous president, Tom Clausen, replaced Armacost in late 1986, and Claus resigned in October 1987.”

Advantages abound in buying COTS products and then customizing them. Some of the pros of buying software are:

  • Lower up-front costs
  • Clear and definite processes available for customization
  • Ready-made solutions available immediately
  • Less time has to be spent on customization and getting a product into the market
  • Readily available customer support

Although buying software may cost more than building a solution at the outset, it does provide better ROI over the long term.

Astera Software provides powerful, commercial, off-the shelf data extraction, integration and processing software including ETL tools which can be easily integrated and adapted by enterprises and companies to reduce time and effort required to perform data extracting and processing tasks and in turn improve revenue.

Some of Astera’s available software include:

centerpriselogo_hd_transparent

  • Centerprise Data Integrator delivers a powerful, scalable, high-performance, and affordable integration platform that is easy to use and cost friendly. It is robust enough to overcome even the biggest and most complex data integration challenges. A complete data integration solution, Centerprise includes data integration, data transformation, data quality, and data profiling in a flexible environment that enables users to choose from multiple integration scenarios. It comes with job scheduling and orchestration for automatic scheduling, file drop events, and API calls.

RMTextLogoTransparent

  • ReportMiner enables you to extract business data from PDF, TXT, XLXS, XLS, etc. formats. Data can be integrated into the main database system and used in electronic applications for business operations and business intelligence. ReportMiner provides an easy to use interface and helps the user to identify desired data, build the data extraction logic, and save the extracted data in a number of destinations. The best part about this product is that it can be used efficiently by business users with no technical background, but is robust enough for IT professionals.

edi-logo-trans

  • EDIConnect is a complete solution for handing EDI documents such as EDI 834 and 837. EDIConnect offers a user friendly and intuitive user interface to accurately and efficiently handle bi-directional EDI data integration. It is scalable and powerful enough to fulfill entire EDI transaction processes.

Astera Software also provides training and support. Customers can learn more about the products, view the demo, and reduce the learning curve. In conclusion, Astera Software provides easy to use, robust and manageable off-the shelf products to support companies and provide them with powerful data mapping, transformation and processing tools that are not only budget-friendly but also have a sizable advantage over building in-house business solutions.

Review our Products, Get a Gift!

_apple_watch_desktop_01

It’s the holiday season, and we’re giving our wonderful customers the chance to win something spectacular! We’ll give you a hint as to what it is: it’s new and shiny and rhymes with, “Snapple Swatch.”

If you use ReportMiner or Centerprise and give us a verified review on G2Crowd, we’ll give you a present back: a $25 Amazon gift card! In addition, you’ll be entered into a raffle to win an Apple Watch Series 2.

The links to review are down below:

Centerprise

ReportMiner

We look forward to hearing from you – remember to get your gift card, and post your review by December 22nd to have your shot at a new Apple Watch. Happy Holidays!

Top EDIConnect Features: EDI Source Files and Parsing

Businesses across the globe send and receive messages via Electronic Data Interchange (EDI). Last week we covered our Centerprise connector, EDIConnect’s, Custom Repository feature. Our focus this week are our number two features for EDIConnect: EDI Source Files and Parsing.

Once an EDI file has been received, validated, and once the acknowledge process is complete, it goes to a dataflow to be parsed and translated. After that, it can be transformed, mapped, and written to destination.

EDI Source File

This reads the incoming EDI messages.  First, create a new Dataflow by selecting File > New > Dataflow. Once a new dataflow opens up, drag and drop the EDI Source File option from the toolbox on the left to the dataflow.

Now, specify source file location information and Trade Partner Profile settings. These contain all information about processing incoming data using EDI Source file properties.

2

To preview EDI source file data, right-click on the EDI Source File box in the dataflow and select Preview Output.

3

The output is in hierarchical format as seen below.

4

EDI Parser

This generates the transaction structure that can be mapped to any destination. The Parser also includes the Trade Partner Profile file: all information required to parse a transaction is in one place. From here, users can specify all transaction sets expected from a partner.

The EDI Parser can be dragged and dropped in to the dataflow using the Toolbox on the left. To set its properties, right-click on it and select Properties. The screenshots below demonstrate the EDI Parser process.

5

6

Mapping

To map the EDI Parser to the EDI Source file, drag the Transaction Node of the EDI Source file onto the EDI Parser file.

7

Destination file

Once the EDI message has been parsed, it’s ready to be mapped to a destination file, such as an XML file as shown in the example below.  Drag and drop the XML/JSON File Destination option from the Toolbox on the left under the Destinations category to the dataflow.

8

Make sure you specify the output file location and provide an XML Schema file that matches the EDI Parser transaction structure to the XML Destination File Properties.

9

Now, map your EDI Parser to your XML Destination File. Your output file is ready to view.

Want to know more about EDIConnect? We’ve been covering our top four EDIConnect features over the past several weeks. Be sure to check back for the final installment in this series!

Top EDIConnect Features: EDI Custom Repository

Many businesses use Electronic Data Interchange (EDI) to send and receive messages. Last week we covered our Centerprise connector, EDIConnect’s, Trade Partner Management features. Our focus this week is our number three feature for EDIConnect: the EDI Custom Repository.

EDI Custom Repository

With EDIConnect, users can customize transaction sets, segments, composite elements, and elements, and store them in a custom repository.

Create a new Custom Repository

To create a new Custom Repository, Select File > New > Edi Custom Repository.

This will create an empty custom repo that contains all the standard definitions for transaction sets, segments, elements and composite elements.

1

Customize a Transaction Set

In the screenshot below, all the standard EDI Transaction sets are listed on the right and each transaction set’s details can be seen and modified once clicked.

2

Custom segments can also be added or deleted.

3 4

Customize Segments/Composite Elements/Elements

As with the transaction sets, every segment, composite element, and element can also be customized: EDIConnect is robust and powerful enough to handle various EDI transaction documents with ease. The screenshots below demonstrate the numerous possibilities to customize EDI documents.

5 6 7

All artifacts that come with standard EDI messages can be modified using EDIConnect and can be stored in an EDI Custom Repository.

Want to know more about EDIConnect? We’re covering our top four EDIConnect features over the next several weeks. Be sure to check back for the third installment!

Handling Benefit Enrollment and Claims EDI Data using Centerprise

One of Astera’s Centerprise connectors, EDIConnect, offers a user friendly and intuitive user interface to accurately and efficiently handle bi-directional EDI data integration. It is scalable and powerful enough to fulfill entire EDI transaction processes. In this blog we are going to focus on how to handle benefit enrollment and healthcare claims data.


EDI 834 – Benefit Enrollment and Maintenance:

The EDI 834 transaction set represents a Benefit Enrollment and Maintenance document. It is a standard format for enrolling members in healthcare benefit plans. It helps electronically exchange health plan enrollment data between employers and health insurance carriers. The Health Insurance Portability and Accountability Act (HIPAA) requires all health plans or health insurance carriers to accept 834A Version 5010 which is a standard enrollment format.

The 834 document is submitted to transfer the enrollment information typically by the employer, to healthcare payer organizations who are responsible for payment of health claims and insurance/benefits. The recipient of an 834 transaction responds with a 999 Implementation Acknowledgement. This confirms whether the file was received and provides feedback on the acceptance of the document.

 

EDI 837 – Healthcare Claim:

The EDI 837 document is required for electronic submission of healthcare claims. It has a standard format established to meet HIPAA requirement for healthcare claim information. This document is used to submit health care claim billing information from healthcare service providers to sponsors.

Healthcare providers must be compliant with version 5010 of the HIPAA EDI standards. The 837 EDI transactions may be sent either directly or indirectly via clearinghouses.

 

EDIConnect

EDIConnect offers data mapping, validation, incoming file translation and information extraction as well as outgoing file construction and acknowledgement generation. EDIConnect also provides automation, process orchestration and job scheduling for automated translation and parsing of EDI documents. It is a complete solution for accurate and efficient bi-directional EDI data integration. It offers EDI capability in an intuitive user interface with visual tools to build bi-directional integration. With built-in transaction sets for incoming file translation and ingestion, advanced data mapping, validation, and correction capabilities to better manage data ingestion, fast and easy outgoing transaction construction, acknowledgement generation, and automation, process orchestration, and scheduling, EDIConnect delivers the power and scalability to meet the most demanding EDI needs within Centerprise.

Want to know more about EDIConnect? We’re covering our top four EDIConnect features over the next several weeks. Be sure to check back for the first installment!

Astera Introduces ReportMiner 7

RMTextLogoTransparent

Astera is excited to announce that ReportMiner 7 is now available.  New innovative features make it one of the most powerful software solutions for document content extraction and integration on the market.

Astera’s ReportMiner enables users to extract data from non-tabular data documents. Users define pattern-based extraction models to extract desired data, transform, and send it to a variety of destination formats, such as spreadsheets, relational databases, and XML files. ReportMiner comes with advanced integration features such as workflow orchestration and scheduling with batch and real-time modes, making it a complete solution for end-to-end unstructured data integration.

This latest release builds on our software’s signature ease of use and intuitiveness with features intended to capture a multitude of new source types and structures.

Key new features in ReportMiner 7 include:

  • OCR for PDFs: This feature is introduced to handle documents containing images. With built-in OCR feature, ReportMiner can read data from scanned PDFs directly within the software.
  • Microsoft Word and RTF support: ReportMiner can now extract data from Microsoft Word and RTF documents.
  • Multi-column layouts: Multi-column (newspaper-style) layouts are now supported for extraction. Visually mark the columns and ReportMiner will automatically apply the extraction logic to each of the columns.
  • Action functions: These context-based functions give control of the raw text while creating formula fields.
  • Forward and backward append: “Append” data regions can work in both directions. User can append data to all preceding records or all succeeding records.
  • Flat Preview: Where applicable, ReportMiner now offers a flattening of the preview grid so users can envision how their data will look when exported to a flat structure such as an Excel spreadsheet.
  • User interface enhancements: With a sleek new interface, brand new visual themes, and many user interface enhancements, ReportMiner 7 offers an entirely custom experience in data extraction.

Availability

ReportMiner 7 is available immediately. For those interested in giving ReportMiner 7 a test drive, a free trial can be requested here. If you’re a current customer and want to upgrade, contact your account manager for more details on how.

Easily Convert Monarch Models to ReportMiner

Attention previous Monarch users! If you have Monarch models you’d like to use in ReportMiner, no need to recreate them! You can load and convert your old Monarch files simply by opening up your Monarch xmods in ReportMiner and they will automatically be converted to a usable rmd. Some users have hundreds of Monarch models, so ReportMiner’s built-in translator for Monarch makes the conversion process easy and saves a lot of time.

Here are step-by-step directions:

Open ReportMiner and click the open file icon 

A window will pop up, enabling you to select your Monarch xmod file.

Once you select your xmod file and click to open, the report options window will pop up and you will point to the file from which you are extracting your data. Monarch xmod files do not store the file location and require you point to the file, but ReportMiner rmd files do store the file location.

 

 

Once you point to your file, ReportMiner will convert the extension from xmod to rmd.

Save your new rmd and that is it!

With the built in converter, the Monarch logic is converted to ReportMiner’s logic. ReportMiner is able to import all models and bring in all logic, fields, and formulas. ReportMiner smart automation features know the patterns and fields and take care of everything behind the scenes.