Tag Archives: expressor etl

expressor Semantic Types blog series: Part 1

This is the first post in a series focused on Semantic Types.  Over the next several weeks, I will walk you through some of the more common problems of data integration applications and describe why traditional ETL products exhibit substantial weaknesses for solving these problems in ways that are manageable over the life of the [...]

Posted in expressor Studio | Also tagged , 3 Comments
 

Back to basics!

We have all heard this expression way too many times before?    Does it ring a bell when you hear our politicians use this term?   Don’t worry, I won’t go there! What I want to do is to indulge you in a little math game.  My game is about asking you how many source to target data [...]

Posted in Competition, Data Transformation, expressor Studio, Semantic Integration, Traditional ETL | Also tagged , , Leave a comment
 

expressor insight series: in-sql motor

expressor 2.3 includes a large collection of connectors (motors) for relational, flat-file, xml, SAS files, Cobol-copybook, and other source and target data formats.  This blog entry is about explaining to you what our in-sql motor in expressor 2.3 is all about. Our in-table motor executes the equivalent of the statement SELECT * FROM table_name, where [...]

Posted in Connectivity, expressor | Also tagged , Leave a comment
 

Who is expressor’s competition in data integration?

This is an important question which I’d like to address in this blog.  As some of you may already know expressor is primarily targeting medium size SMBs and departmental projects in Global 2000 enterprises. Important sectors in this market are Microsoft-centric SQL Server accounts that are using Microsoft SSIS for standard ETL tasks.  expressor commonly [...]

Posted in Competition, Connectivity, expressor, expressor Studio, Open Source ETL, Traditional ETL | Also tagged , , , , , , , , Leave a comment
 

SQLSaturday #35 in Dallas – May 22, 2010

expressor and our SI partner Novedea are co-sponsoring the 2010 SQLSaturday event in Dallas on May 22, 2010. Please stop by at our booth. Michael Waclawiczek VP, Marketing

Posted in Competition, Connectivity | Also tagged , , , , , , , Leave a comment
 

expressor vs SSIS: overcoming two major SSIS bottlenecks

I’d like to use this blog entry to discuss some significant SQL Server Integration Services (SSIS) bottlenecks and how expressor breaks through them. SSIS prospects often ask us if expressor supports sub-sorts and sorted aggregations, avoiding the need to see all data before releasing some of the data for downstream operations and the inherent “pipeline [...]

Posted in Competition, Connectivity, Data Processing, Data Transformation, Scripting | Also tagged , , , Leave a comment
 

insight series: how to define parallelism in expressor

The following is an excerpt from the upcoming white paper by Microsoft MVP and SSIS guru Andy Leonard, “SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transofrmations,” published by SQL Server Magazine and sponsored by expressor: …There are multiple opportunities for implementing the application in parallel [in expressor].  expressor provides dynamic parallelism at runtime [...]

Posted in Data Processing, expressor | Also tagged Leave a comment
 

Feb 11 “deep dive” technical webinar

On February 11, Hugo Sheng, our director of field engineering, will be hosting a technical webinar on the expressor semantic data integration system.  During the event, he will discuss five key aspects of expressor, including: product architecture – from interface to engine to application semantic rationalization – its conceptual framework and practical application collaborative team development – the [...]

Posted in expressor | Also tagged , , , , , , , , , Leave a comment