Back to Index

 

The Data Objects

.NET Data Provider

Generic .NET Provider object used for all 3rd party .NET data providers.  If your database vendor supplies a .NET data provider specific to their database, it is best to use this data object.  In most cases, the database specific data provider provided by your database vendor is optimized for use with their particular database.  For instance, Oracle® offers ODP.NET (Oracle Data Provider for .NET) which is highly optimized for use with Oracle databases and uses direct access through SQL*Net.

MS SQL Data Provider

MS SQL Server data provider specifically for Microsoft® SQL Server databases.

MS Excel spreadsheets

The MS Excel spreadsheet object is a custom object used specifically to read / write Excel spreadsheets.  It uses the OleDb Jet driver, but has all of the properties predefined for faster configuration.

MS Access database

The MS Access database object is a custom object used specifically to read / write to/from Access database tables.  It uses the OleDb Jet driver, but has all of the properties predefined for faster configuration.

OleDb

OleDb is a COM based database interface that can be used with any OleDb driver.  Most major database vendors typically supply an OleDb driver with their system.

Odbc

Odbc (open database connectivity) uses any compliant ODBC database driver.  Most major database vendors offer ODBC drivers with their system.  Although ODBC is typically slower than the newer methods of interfacing to databases, it is usually very easy to find an ODBC driver for your database given its wide, standards-based acceptance.

Text Files

The Text object allows you to access most types of row/column based text files.  You can define fixed width or delimited, as well as DOS and UNIX style text files.

Hash Tables

Hash tables are very fast key - value pairs that are organized based on the hash code of the key.   They are basically index organized tables.  When you load a Hash table in BlueSky Integration Studio it saves the information into a file that you can later access in any other design job.  When the job runs, the highly optimized hash table is pre-loaded directly into memory giving you blazing fast lookups!   Hash tables might sound a little more complex than other typical databases or files, but they are just as easy to use as any other data object in BlueSky Integration Studio.  Don't ignore them, they can literally increase the speed of your job 100 times!

Oracle Bulk

The Oracle Bulk loader object builds an Oracle bulk load control file that you can use in conjunction with Oracle's SQL*Loader tool.   Oracle Bulk loader provides a great way to load large amounts of data into an Oracle database a lot faster than using conventional SQL statements.

EDI object

The EDI object is an input only object that gives your BlueSky Integration Studio jobs the ability to parse out and read EDI X12 data files.  This functionality requires a separate BlueSky Integration Studio license.  Please contact us at rsi@relationalsolutions.com for more information.

Batch Code

The Batch Process object serves two major purposes in BlueSky Integration Studio.  First, it gives you the capability to batch other jobs together into a single job and, if necessary, write logic around the jobs to control how and when they are executed.  Second, it serves as a wrapper function where you can write your own custom code that you want executed as part of the job.  

Execution

Execution is a shell command object that gives you the capability to call external programs (.exe, .bat, etc.) at different times throughout the life of your job.   For instance, you want to call a batch file to FTP a file somewhere after the job completes...

FTP

The FTP object allows you to initiate a File transfer before or after your job completes.

Mail

The Mail object is an SMTP mail control so you can send e-mails during your job.  There are 3 events when you can send e-mail:  JobStarts, JobFinished and JobAborts.

DataBeacon

The DataBeacon object allows you to automate the creation of DataBeacon cubes during the execution of any BlueSky Integration Studio job.  Please note: this functionality requires a special license to be obtained through DataBeacon, Inc.

Comments

Comments is a simple area within your job for documentation.  It is always good to document exactly what your job is doing, especially in the case where multiple developers are working on the same team.

 


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