Back to Index |

What is BlueSky Integration Studio?

BlueSky Integration Studio is one of the most useful, cost-effective and productive tools on the market today for .NET developers! Whether you are building integration processes for multiple locations around the world, or you simply need to extract and transform information within your single database environment, BlueSky Integration Studio will be the tool you want in your toolbox. BlueSky Integration Studio is a BlueSky Integration design environment for extracting, transforming and loading data from any data source – to any data source allowing you to write code behind the transformation process in Visual Basic .NET. Why buy an integration tool with yet another proprietary language to learn when you can take complete advantage of your existing VB and .NET knowledge!

These are just few way our customers are using BlueSky Integration Studio today:

| Cleanse and load data from disparate data sources |  | Build B2B integration processes
| Build complex processing designs and call them directly from your .NET programs via the VIS.NET Components |  | Extract, Transform and Load (ETL) for Data Warehouse and Business Intelligence systems
| Easily extract and transform data from one database or file to another |  | Refresh information in Portal databases and ASP.NET web applications
| Automation of nightly batch processing functions |  | Generate the VB.NET code for your designs and embed it directly into your own custom .NET programs
| Build integration processes for bolt-on systems |  | Generate the .NET component (.dll) for your designs reference it directly from your custom .NET programs

Designer Features

BlueSky Integration Studio's designer is an effective, easy to use development environment used to design your data integration and processing jobs.

The designer’s intuitive drag and drop / property-based interface makes is very easy to build designs quickly, increasing your productivity exponentially compared to that of hand-coding.

Data mapping and transformation

BlueSky Integration Studio's powerful data mapping and code behind interface gives you ultimate flexibility to control the flow and transformation of your data using standard VB.NET code. Mapping columns to any data source is as easy as dragging the column and dropping it into its destination.

Other features include:

Unlimited input data sources that you can join together | Filtering logic using standard VB.NET code. Put some intelligence into your filter!
Quick access to the Code store library | Quick column selection tree
Syntax highlighting and smart drop down lists. | Easy to understand graphical flow interface

Job Deployment Features

Once you design your job you have 3 powerful options for deployment.

- Server Executable Jobs (.exe)

Let BlueSky Integration Studio manage your integration jobs! BlueSky Integration Studio compiles your design into a true .NET executable and stores it in the server repository. There are no code interpreters here to slow things down! BlueSky Integration Studio jobs are fast, compiled executables taking full advantage of the .NET Framework’s managed code and memory features. Once your job is compiled you have complete control in the Job Control window to Run your job, check output logs, schedule your job and even monitor its progress in real-time!

- .NET Component (.dll)

Stop hand-coding your data processing logic! In BlueSky Integration Studio, you simply design your process, compile it to a .NET component and reference it from your code. Not only will your data processing logic be done in record time, but also maintenance down the road will be much faster. Want to make a change? Simply open your design, make your change, re-compile, and update the component in your .NET application’s directory! You don't even have to re-compile your application!

- Source code (available in the Enterprise Editions)

Your a developer, we understand! You want complete control over your software and you need to understand, and have control over every part of it. Who are we to limit you? BlueSky Integration Studio will give you every line of code for any integration job you can design. How does this thing work anyway? See for yourself – we have no secrets! BlueSky Integration Studio generates every line of VB.NET code for you. No proprietary external components or libraries are used. How did we write that Excel file? How do we use XML Serialization to output objects on the fly? How did your job send that e-mail? .... you can see it and use it all!

Job Control

The Job Control Window gives you total control over the execution and monitoring of your integration jobs. With easy to use VCR style buttons and real-time job monitoring you always know what’s going on.

- Real-time monitoring: Watch your integration jobs work in real-time showing current record counts and useful statistics such as records per second.

- Job logs: The Job logs gives you in-depth insight into what your job is doing behind the scenes which allows you to quickly fix any problem that occurs.

- Scheduling (enterprise edition): Automate all of your integration jobs through the job scheduler.

Extensibility

- Reference external components: You can easily extend the capabilities of BlueSky Integration Studio by referencing your own custom libraries, and/or libraries from 3rd party vendors. Simply reference the component, add any Import statements necessary and you have instant access to all the additional logic you need to accomplish your integration goal.

- BlueSky Integration Studio's Code Store lends to re-usable code throughout the system! Code Store gives you the capability to create and test global functions on the fly that can be used in any job. The functions are easy to create and test because you get immediate feedback on whether your function works. Due to the incredible power built into the .NET framework, BlueSky Integration Studio can literally compile your function, pass it your test data and return the results back to you, allowing you to unit test the function before putting into production!

Test Code on the fly!

Security

BlueSky Integration Studio allows you to control who has access to your designs and job control capabilities. Users are setup and given access to the 3 major components of the system, by application domain: Administration, Design, and Job Control. For instance, you could design a job and compile it, but maybe you want the user to control when it runs, effectively off-loading the management of that job to another user. No problem, just give the user access to only the Job Control functionality of the system. They will be able to run and monitor the jobs progress, but will have no capability to change the actual design.

You can also segment your developers into groups by application domain so that one group of developers cannot access jobs from another group of developers.

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved