Back to Index

 

Designing Jobs

BlueSky Integration Studio's intuitive, property-based interface makes designing integration jobs quick and painless.  This section will walk you through designing integration jobs.  Designing a job can be broken down into 4 basic steps:

Designing the process flow

Every data object must flow through a Join object.  Think of the Join object as the black box in the middle of any process that performs the actual mapping and transformation work.  Each Join object is a separate process within a job.

Dragging an object onto the designer window

Connecting the data objects using the connection object

Understanding the Execution Path

You can have multiple Join objects in a job design.  When BlueSky Integration Studio compiles your job it goes through a complex set of algorithms to determine the execution path for job.  The execution path is essentially a dependency tree which looks at the job design and determines which objects are dependent upon one another.  For instance, the "Brand Code Lookup" table below is required for the "Sales Mapping" process to run correctly, so the "Load Brands" Join process has to run first.

The execution path is calculated automatically anytime a job is compiled.  You can run the execution path manually as well by selecting the Build->Execution Path menu item, or by clicking the Execution Path icon on the toolbar.  

Complex jobs

A more complex job might look like this:

Let's walk through this job step-by-step:

Aliases

What's up with those little object aliases (a1, a2, a3, etc...).    Object Aliases serve two main purposes.  

  1. Each object in BlueSky Integration Studio must have a unique name.  Essentially, BlueSky Integration Studio is building a program behind the scenes that will eventually get compiled into an executable or .NET component.  Each object in your design becomes a unique class in the program's source code, hence it must be unique.  You can name the Alias anything you want through object properties, however no spaces or special characters are allowed.

  2. Aliases come in handy when you are coding your transformation code in VB.NET.  Since each object is a class, and that class contains properties (the columns), it then becomes much easier to code.  For instance, say for instance you named one of your Aliases 'emp' for Employee information.  You would then access the fields in 'emp' like:  emp.FIRST_NAME

Designing the process flow

Defining properties

Mapping and Transformation

Compiling Jobs


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