This is probably the best data integration software I have used. It is very stable and easy to use. You just drag and drop data sources and target loads into place (ODBC, OLEDB, Oracle, SQL Server, text, Excel, FTP, Access, etc.) on the pallet. There is a Join stage where you map source columns to target columns. You can use VB.NET code to clean/transform the data. You can save the entire data flow as a executeable (.EXE), component (.DLL) or .NET source code to use in .NET applications. We kick off the .EXE from the command line but this product has its own scheduler. Its cool. |