Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 A Quick TIBCO Object Service Broker Tutorial : Task A: Create a Table Definition to Access an External Data Source

Task A: Create a Table Definition to Access an External Data Source
TIBCO Object Service Broker stores data in tables. There are a number of different types of tables, with the table type reflecting the data source and the intended use for the table in an application. You define tables using the Table Definer tool.
When using an external data source, the basic principle is to make external data look just like TIBCO Object Service Broker data. The programmer writing the application does not need to be aware of the structure of the external database. However, the external data structure must be mapped to a TIBCO Object Service Broker table structure through the Table Definer.
This task has you creating the import (IMP) table that you will need to access the external data source.
Defining an Import (IMP) Table
To define a table, complete the following process:
1.
Because you are creating a table definition that will import the data from a text file, select IMP, which stands for import, as the table type from the drop-down list.
2.
Use the Table Definer panel, which is displayed after pressing Finish, to specify the location and name of the text file, as well as the name and description for each of its fields.
Source for the Games
The information about all NHL games for the 2006-2007 season is available from the text file shown here:
About the Data
Each field is described by its properties in the external data source (i.e., external syntax, external length, offset…) as well as by its TIBCO Object Server Broker properties (type, syntax, length…)
As shown in the illustration above:
When you input the values for external syntax and length, the Table Definer offers the corresponding values for TIBCO Object Service Broker syntax and length of the field; you can accept the suggested values or change them.
This is the definition of the fields in the Table Definer:
After creating and saving the definition, you can use the Table Browser to see the contents of the file from within the TIBCO Object Service Broker UI:
By creating the table definition, the contents of the external data source are made available to TIBCO Object Service Broker. You can now use the rules language to store it internally, analyze it, transform it, etc.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved