Posts Tagged ‘ETL’

Top Ten Reasons for Selecting Centerprise over SSIS

1. Superior Usability While consumer products have made major strides in improving product usability, business software products still lag behind in that area. Increasingly, companies are realizing that superior product usability results in shorter learning curves, makes the product more approachable to a broader audience, and results in substantial productivity improvements. Centerprise is designed from [...]

Name and Address Parsing and Correction

We are pleased to announce the availability of name and address parsing and cleansing functionality for Centerprise Data Integrator. This feature provides sophisticated name parsing, address parsing, address cleansing, and gender determination capabilities. Key features include: Name Parsing and Gender Determination Centerprise integrated name component accepts free-form names and then automatically splits them into standard [...]

Creating High Performance Dataflows in Centerprise

Centerprise is designed to deliver performance and scalability that enables you to efficiently process high data volumes. Centerprise’s parallel processing architecture exploits multicore and multiprocessor hardware and delivers performance that usually increases linearly with the CPU power available. When working with high volume data, it is important to understand how Centerprise processes data as it [...]

Generic OLE DB Support in Centerprise Data Integrator

Centerprise delivers a wide range of connectivity to databases, file formats, and applications. These include native connectivity to popular databases such as Microsoft SQL Server, Oracle, DB2, MySQL, Sybase, Teradata, Netezza, Access, and others. Additionally, a generic ODBC component is provided to connect to any ODCBC data source. Centerprise now includes the capability to connect [...]

Real time data integration coming to Centerprise

We live in an on-demand world where latency of incoming data is increasingly becoming an important factor in modern data integration platforms. Using a low-latency or zero latency solution to process data in real time can have a major impact on business intelligence and time-dependent, business-critical decisions. Centerprise 5.0 already boasts of a state of [...]

Centerprise 5.0 Released!

Centerprise Data Integrator 5.0 is now available.   If you’ve been participating in our beta program, we thank you and invite you to download the released version of Centerprise.  You can find it at the same download location you were given for the beta version or you can contact sales@astera.com.

Source Control In Centerprise

With Centerprise’s file system approach, putting meta data files such as transfers and dataflows under source control was always possible.  But now, we’ve added a built-in, fully-functional source control client right in the studio UI.  If you’re familiar with Microsoft’s Visual Studio, you’re probably already familiar the concept of integrated source control and know how [...]

Slowly Changing Dimensions in Centerprise 5

Maintaining dimension tables in a data mart is quite a chore. We have talked to customers who spend a great deal of time writing SQL scripts, stored procedures, or other code to perform this function. Often, the code is written or duplicated for each dimension table and must be modified regularly to accommodate changing business [...]

Centerprise 5 Beta Release is now available

I am pleased to announce that Centerprise Data Integrator 5 beta is now available for download. This release represents a major upgrade and adds sophisticated dataflow and workflow designers. We are very excited about this release and the great deal of value it can add to our customers’ business. Centerprise 5 represents an attractive alternative [...]

Upcoming Centerprise Upgrade and Microsoft.Net 4.0

Earlier this month, Microsoft released Visual Studio 2010. Along with VS 2010, Microsoft also released version 4.0. .Net 4.0 brings new features and improvements in a number of areas. Centerprise team has been working on a major new upgrade for some time now. Last fall, when Microsoft released preview version of Visual Studio 2010, we [...]