Back to Index

 

  The DataBeacon Object

Relational Solutions is proud to announce our partnership with DataBeacon!  

BlueSky Integration Studio is used heavily in the Business Intelligence market, so it only makes sense to partner with one of the best makers of cube technology in the business.   We've embedded DataBeacon's powerful cube building technology right into the software to make it easier for clients to extract, transform and load data, then build their DataBeacon cube's all in one simple process!

Please note:  This technology requires a special license which can only be obtained from DataBeacon, or one of DataBeacon's many partners.  Please contact DataBeacon directly to obtain this license.

Properties

AdditionalProperties

Enter any additional properties you would like sent to the DataBeacon cube builder (ex: -ecubeonly, or -v for verbose output)

BuilderLocation

The full path and file name to the DataBeacon cube builder software.  Defaults to: "C:\Program Files\Databeacon\Databeacon-Smart_1_1\bin\dbaccess5.exe".  Please be aware that the command is wrapped in double quotes.  This is used when the path contains long filenames and/or spaces.

Command

Not editable, please use BuilderLocation.  This property is simply showing the user exactly what will be sent to the OS on the command line.

CommandLineArguments

Command line arguments to pass to the DataBeacon Cube Builder.  This is automatically generated by the other properties.

Comments

Comment area to give descriptive text about the data object and its purpose.

CubeLocation

The full path and filename of where you want the resulting cube file to be built.  If left blank, the location will default to the same path and name given in the ProfileLocation property, but with a .cb4 file extension.

Please be aware that this property may need to be wrapped in double quotes.  This is used when the path contains long filenames and/or spaces.

Email

Many times it is necessary to e-mail a resulting cube file to someone.  For instance, this is extremely useful when building individualized cubes for sales people.  You can simply e-mail them the cube file for use on their local machine!   

Click on the ellipse button to enter the necessary e-mail information.   You can also use Parameters, allowing you to re-use a single job for many different cube builds

Excludes

Exclude any category or measure from this particular cube build.   Click on the ellipse button to use the simple wizard interface.

Execute

BeforeJob / AfterJob.  When the job should execute the given cube builder command.

ExecutionOrder

In the case where multiple DataBeacon objects are used, this parameter specifies the order in which the objects should be called.  (0, 1, 2, 3...)

FTPWizard

Many times it is necessary to FTP a resulting cube file to another machine.  For instance, to a web server.  Click on the ellipse button to enter in the necessary FTP information.

Name

Descriptive name for this object.  You can enter any text to describe the object.

Parameters

DataBeacon now offers parameters to be used in the DataBeacon profile.  This simple wizard allows you to enter values for those parameters for this particular cube build.   Click on the ellipse button to enter the necessary parameters.

ProfileLocation

The full path and file name to the DataBeacon profile that will be used to create the cube.

Please be aware that this property may need to be wrapped in double quotes.  This is used when the path contains long filenames and/or spaces.

TailOutput

If the Command that executes returns output, this property specifies the maximum number of characters to return from the output.  Use this in cases where the output may be very large and you only need to see the last 'x' characters to ensure its successful completion.  *Note: 0 returns all characters. (default)  WaitType must be set to Wait otherwise this property is ignored.

Timeout

 

If WaitType = Wait, you can specify a timeout period based on seconds.  If the command does not complete in 'x' seconds the process will timeout.  Can be used to ensure a job doesn't hang forever.  *Note 0 waits forever (default)

WaitType

 

Wait / NoWait:  specifies if the job should wait until the command has completed, or continue on without waiting.

WatermarkLocation

The full path and file name to the DataBeacon watermark file.  

Please be aware that this property may need to be wrapped in double quotes.  This is used when the path contains long filenames and/or spaces.

 

 


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