ETL tools

Following are top ETL tools used for extracting, cleaning, transforming and loading data to a data warehouse:

1. Oracle Warehouse Builder (OWB)
2. SAP Business Objects Data Integrator (BODI)
3. IBM Data Stage
4. Microsoft SQL Server Integration Services (SSIS)
5. SAS Data Integration Studio
6. Talend Open Studio
7. Clover ETL
8. Adeptia Integration Suite

Business Intelligence experiences

During my 17-plus years of being a business owner or employee, I've had the opportunity to implement, feed, test or used a Business Intelligence (BI) product including Cognos, Microsoft's PerformancePoint Server Planning(discontinued) and now Business Objects. I like the look and feel of this product but wonder what will change in 2010 since SAP took over. Nowadays, database vendors provide Business Intelligence solutions in their product line and you can check vendors like SAS (Voted by Fortune as the top company to work for in 2010), Oracle, Microsoft, IBM and now SAP.

You can add value to your customers if you can implement a BI solution right on top of their ERP/SCM/CRM system.

BI according to Microsoft

The Microsoft BI team presented the new BI stack to the New York Business Intelligence New York Meetup group yesterday. The first part of the presentation was the product demonstration then an open discussion on the product functionalities which got too detailed. A comparison of Excel 2007 and Proclarity was also in the table but was cut short because it was out of content. It was refreshing to see ProClarity working in harmony with PerformancePoint Server and MOSS.

To get more info about Microsoft BI click here. To join the New York Business Intelligence Meetup click here.