cooper to logan http://www.beyeblogs.com/expressor/ expressor semantic data integration blog is now hosted at http://blog.expressor-software.com. en Copyright 2011 Wed, 10 Aug 2011 06:45:00 -0700 http://www.movabletype.org/?v=3.33 http://blogs.law.harvard.edu/tech/rss SQL SERVER – Who needs ETL Version Control? While making some changes (read: mistakes) to my ETL business logic the other day, it occurred to me much too late that those unfortunate changes had replaced the once properly working logic with now very flawed logic. The good news was that I remembered what the working logic was supposed to be. The bad news, I had to re-create it. Had I had the working logic already checked-in under version control, I could have saved myself the two hours of wasted time and effort. In an ETL team development setting, these types of issues could easily multiply and significantly impede developer progress and productivity.

Read full blog post by Pinal Dave, Microsoft MVP, at http://blog.sqlauthority.com/2011/08/10/sql-server-who-needs-etl-version-control/.

]]> http://www.beyeblogs.com/expressor/archive/2011/08/sql_server_who_needs_etl_versi.php http://www.beyeblogs.com/expressor/archive/2011/08/sql_server_who_needs_etl_versi.php Wed, 10 Aug 2011 06:45:00 -0700 Major download milestone achieved. This week expressor software hit 10,000 unique downloads of expressor Studio, our desktop ETL product. Most of the open source companies quote ridiculous numbers like 11 million downloads, which of course means they count everything, like white papers, brochures, product documentation, etc. We count only unique users of our software.

More importantly, we’re demonstrating that there is a big appetite out there for feature-rich, innovative, and affordable data integration software. The growth of data continues to accelerate, and it’s getting messier not cleaner. Without the right solutions, it’s getting harder—instead of easier—to turn data into insight. Companies, government institutions, non-profits, schools and all organizations that employ more than a handful of people are trying to get more value from their data with fewer resources.

That’s why expressor Studio resonates with them. You can download expressor Studio at www.expressorStudio.com.

]]> http://www.beyeblogs.com/expressor/archive/2011/08/major_download_milestone_achie.php http://www.beyeblogs.com/expressor/archive/2011/08/major_download_milestone_achie.php Thu, 04 Aug 2011 13:45:00 -0700 expressor product roadmap 2011

]]> http://www.beyeblogs.com/expressor/archive/2011/08/expressor_product_roadmap_2011.php http://www.beyeblogs.com/expressor/archive/2011/08/expressor_product_roadmap_2011.php Mon, 01 Aug 2011 22:30:00 -0700 expressor 3.3 demo webinar

]]> http://www.beyeblogs.com/expressor/archive/2011/06/expressor_33_demo_webinar.php http://www.beyeblogs.com/expressor/archive/2011/06/expressor_33_demo_webinar.php Sun, 26 Jun 2011 18:30:00 -0700 SQLAuthority.com posts on expressor software
Pinal Dave, SQL Server MVP, has been following expressor software since the launch of expressor 3.0 in the fall of 2010. Here are his posts on the expressor Data Integration Platform and expressor Studio, a free desktop ETL tool:



Download and test-drive expressor Studio - it's free.


]]> http://www.beyeblogs.com/expressor/archive/2011/06/sqlauthoritycom_posts_on_expre.php http://www.beyeblogs.com/expressor/archive/2011/06/sqlauthoritycom_posts_on_expre.php Sun, 19 Jun 2011 08:30:00 -0700 expressor 3.2 webinar on business data processing

]]> http://www.beyeblogs.com/expressor/archive/2011/06/expressor_32_webinar_on_busine.php http://www.beyeblogs.com/expressor/archive/2011/06/expressor_32_webinar_on_busine.php Fri, 10 Jun 2011 18:15:00 -0700 Leading email marketing services firm for financial institutions deploys expressor 3.2 ClickRSVP, a leading provider of email-marketing and web marketing services for financial institutions in the U.S, has deployed newly developed data integration application that populates and updates their production database with input files from various ClickRSVP customers in less than a week.

More at http://www.expressor-software.com/clickrsvp-announcement.htm

]]> http://www.beyeblogs.com/expressor/archive/2011/05/leading_email_marketing_servic.php http://www.beyeblogs.com/expressor/archive/2011/05/leading_email_marketing_servic.php Wed, 25 May 2011 07:30:00 -0700 Rapidly process, cleanse, and normalize your business data expressor Business Data Quality Solution webinar

Rapidly process, cleanse, and normalize your business data to improve quality and streamline business processes

Join us for a live webinar on
June 2, 2011, 2pm ET

Presented by: expressor software

Speaker:
Wiqar Chaudry, Product Manager, expressor software

Register today:

http://go.expressor-software.com/business_data_quality_solution_webinar.html

Abstract:

In today’s environment, companies are challenged with improving the quality of their data and reconciling dissimilar data from various information sources scattered across departmental data silos. The lack of reusable data quality rules and easy ways to unify dissimilar data to a common data format makes it difficult to streamline business processes and provide a unified picture of the business.

Although there are other vendor solutions available for these data challenges, expressor software provides a unique method for speeding up and simplifying the process of developing a canonical, validated representation of your data regardless of the heterogeneity of it sources.

The expressor Business Data Quality Solution delivers a powerful new approach to data cleansing, mapping and transformation by allowing users to define and maintain Semantic Types. Instead of defining point-to-point, source-to-target mappings and individual rules, you can define a Semantic Type representative of your business data, create reusable business rules and constraints, and then easily transform your data to any target format.

By attending this webinar, you will:

- Learn more about the IT / data challenges found in many data processing-intense businesses
- Gain a deeper understanding of expressor’s unique, built-in approach to data quality
- See a demonstration of expressor’s Business Data Quality solution
- Learn about the business benefits customers can achieve in terms of cost savings and improved business processes

]]> http://www.beyeblogs.com/expressor/archive/2011/05/rapidly_process_cleanse_and_no.php http://www.beyeblogs.com/expressor/archive/2011/05/rapidly_process_cleanse_and_no.php Wed, 18 May 2011 11:30:00 -0700 Q2 2011 interview with expressor CEO Bob Potter

]]> http://www.beyeblogs.com/expressor/archive/2011/05/q2_2011_interview_with_express.php http://www.beyeblogs.com/expressor/archive/2011/05/q2_2011_interview_with_express.php Sun, 15 May 2011 17:45:00 -0700 Over 5000 downloaders for free expressor Studio ETL tool expressor Studio is rapidly gaining traction in the marketplace and now has over 5,000 unique download users adopting this exciting new ETL tool.

The next version of the free expressor Studio product is expected to be released in early May 2011.

You can download your free copy of Studio at www.expressorStudio.com.

]]> http://www.beyeblogs.com/expressor/archive/2011/04/over_5000_downloaders_for_free.php http://www.beyeblogs.com/expressor/archive/2011/04/over_5000_downloaders_for_free.php Mon, 25 Apr 2011 08:45:00 -0700 A new wave of data integration This special episode of Bloor Research's "The Briefing Room" was sponsored by expressor software and features industry visionary Colin White and expressor CEO Bob Potter. Click the Start button below and begin watching this very informative webinar.

Jan 18 2011 The Briefing Room Presentation
View more videos from expressor software
]]> http://www.beyeblogs.com/expressor/archive/2011/03/a_new_wave_of_data_integration.php http://www.beyeblogs.com/expressor/archive/2011/03/a_new_wave_of_data_integration.php Tue, 22 Mar 2011 22:00:00 -0700 expressor blog series on Semantic Types Bill Kehoe, expressor's chief architect, has recently completed a five part blog series on Semantic Types.

Part 1: data integration challenges

Part 2: A sample ETL application

Part 3: Messy data

Part 4: Mapping external data

Part 5: Building ETL data flows

]]> http://www.beyeblogs.com/expressor/archive/2011/03/expressor_blog_series_on_seman.php http://www.beyeblogs.com/expressor/archive/2011/03/expressor_blog_series_on_seman.php Tue, 08 Mar 2011 05:30:00 -0700 expressor announces Standard Edition expressor 3.1 Standard Edition provides the server components of the expressor Data Integration Platform. It extends the free expressor Studio ETL tool to facilitate team development, version management, and deployment of ETL applications to a standalone parallel processing server.

Go to http://www.expressor-software.com/standard-edition.htm to learn more about this new edition.

]]> http://www.beyeblogs.com/expressor/archive/2011/02/expressor_announces_standard_e.php http://www.beyeblogs.com/expressor/archive/2011/02/expressor_announces_standard_e.php Sun, 27 Feb 2011 21:45:00 -0700 ETL: expressor Studio database support expressor Studio 3.0 is a free, easy to use ETL tool that greatly simplifies data mappings and offers a level of business rule reuse not found in other ETL tools. expressor Studio provides high-performance connectivity support for all major RDBMSs and data warehouse appliances along with generic ODBC connectivity.

Using expressor Studio's generic ODBC connector, database connections can be made through an ODBC DSN to any ODBC 3.5 (or higher) compliant data source. The generic ODBC connector provides read, write, update, and delete support. expressor Studio also ships with high-performance provider-specific connectors to mainstream RDBMS databases including:

- MySQL Community and Enterprise Editions, versions 5.1 and 5.5
- Microsoft SQL Server versions 2005 or 2008
- Oracle versions 8, 9, 10 and 11
- PostgreSQL versions 8 and 9
- Sybase ASE, versions 11, 12 and 15
- Teradata versions 12 and 13
- Netezza versions 4.6, 5 and 6
- DB2 versions 7, 8 and 9

You can download expressor Studio for free at www.expressorStudio.com.

]]> http://www.beyeblogs.com/expressor/archive/2011/02/etl_expressor_studio_database.php http://www.beyeblogs.com/expressor/archive/2011/02/etl_expressor_studio_database.php Sun, 13 Feb 2011 17:00:00 -0700 The simple things in life sometimes aren't so simple Have you ever had an Excel or CSV file that was too large to handle with Excel? Wish you could just load it into a database of your choice for analysis from your desktop? You imagine it should be simple, but it isn't because your database tools have limitations in terms of speed, configurability, and access.

What if there was a simpler way to access any database and load any table or file - and it was FREE?expressor Studio is FREE and is designed with you in mind. It is so easy to install, you'll be loading files in no time at all.

Join us for a weekly demonstration every Tuesday or download expressor Studio today. You might just be surprised by what else this product can do.

]]> http://www.beyeblogs.com/expressor/archive/2011/02/the_simple_things_in_life_some.php http://www.beyeblogs.com/expressor/archive/2011/02/the_simple_things_in_life_some.php Fri, 11 Feb 2011 20:30:00 -0700