BlueSky Integration Studio is a powerful data integration, ETL and process automation tool that reduces the risk of failure for complex, data integration projects associated with data warehousing, data management, master file data management, application integration, etc.
• Easy integration of EDI data
• Scheduler to look for new data and automatically update the database as new data arrives
• Written in .Net
• Simple drag and drop of data sources and elements from any data source to any data source.
• Supports in-memory lookup tables for high speed data validation. Also has a Job Sequencer
• Filtering of exception data
• Data mapping & transformation
• Generates .NET Source Code. Also, a .NET executable, it is automatically stored in a repository where you can run it at will, stop it, view the log files, and monitor jobs in real-time. You can watch the data flowing through the process and monitor statistical information such as records-per-second.
• Server and repository can be located on a powerful server-based system where they can be batched together into a complex process and automated with BlueSky Integration Studio Scheduler service.
• Integration objects include ODBC, OLEDB, MS SQL Server, SQL Bulk Loader, Oracle ODP.net, Oracle Bulk Loader, My SQL, Text files, Memory Table, Hash Table, Excel, Access, Generic .net, EDI, Database switcher, Teradata, DB2 .net, DB2 Bulk Load & stored Proceedures, Wal-mart Retail Link