Business Information Server Integrating the World
Frank AndristSystems Analyst
Topics
• ICE / BIS object
• ODBC
Happy 40th Birthday!
iceDrill
iceDrill is a browser-based display tool that provides an additional way to expose and integrate your enterprise data in Web presentations and applications developed with the Internet Commerce Enabler.
It allows your internal and external customers to view and dynamically interact with information from a variety of data sources through an intuitive display interface. You can use this powerful display tool in presentation or applications built for
• Internal uses such as decision support, order and shipment tracking
• External customer transactions such as product selection for order entry
iceDrill
This powerful, easy-to-use browser-based tool that enables you to:
• View and manipulate the customized information you need from the Internet or yourintranet.
• Select a report you want to view from lists tailored for your use. • You can run these predefined standard reports against live data at the click of your mouse. • Perform ad-hoc queries using simple, easy-to-follow dialog boxes. • You can specify Boolean, date, time, range, and numeric searches to be carried out on
appropriate data. • You can also build complex calculations, produce subtotals based on intervals for selected
fields, and reformat and resort filtered data sets into tabular reports. • Perform a series of tasks with one click of your mouse using predefined queries associated
with the currently displayed iceDrill table.• Transform tabular data into various graphic formats such as bar charts or pie charts.• Export filtered, sorted, and formatted data with any calculation results to a Microsoft Excel
spreadsheet.
Data-Source
1
Data-Source
1
Data-
Source 2
Data-
Source 2
Data-Source
n
Data-Source
n…
Management Reporting
iceDrill
Component Builder
• Gathers data from up to five data sources
• Manipulates the resulting data as a table
• Formats this data as a form, table, or graph
• Reformats your data for display
• Converts data to and from XML
What's New in the Component Builder Released with BIS/ICE 10.1?
XML mapping
• Mapping XML documents that contain one or more repeated nested structures with data inside of a repeated nested structure.
• Choice structures containing alternatives selected under different circumstances.
• Support for XDR schemas to define an XML element tree for mapping.
• The ability to read in and handle a larger set of Document Type Definitions or schemas by either pruning away unneeded parts of a DTD or schema or extracting one part of a DTD or schema.
• Support for mapping to a set of tables joined by primary and foreign keys.
• Improved build and load times.
Calling ICE/BIS
• ASP object– Web access to BIS resources
• Server object– Microsoft .Net program (VB, C#, etc.) access to BIS resources
• Java (with BIS-RA)
• ODBC (Excel, Access, Calc, Base)
• BPRUN$
Of course BIS can also call objects using @CCC (COM Client Create Instance)
ODBC serves up your BIS data fast and easy.
• You can make your BIS data available as an ODBC data source– Call from Excel, Access, other desktop applications
– Data appears just like any other ODBC data source
• Install the BIS ODBC driver on user's desktop– Driver is packaged on the BIS installation media
– Security uses a BIS sign-on. (user-ID, dept, password)
• Define a virtual "table" using a BIS data report or the output of a BIS script– Expose only the columns you wish
– Control access to table using BIS department numbers
Unisys ODBC Server – Overview
32 Bit client only
Unisys ODBC Server – Data Sources
• A Business Information Server report.• A set of contiguous Business Information Server reports in a single drawer.
The term span refers to this set of reports.• The results of a script, which create a specific view of one or more
Business Information Server reports.
• If the table definition allows updates, users can update BIS Server report datausing the SQL SELECT, INSERT, DELETE, or UPDATE commands from an ODBC compliant tool.
• If the table definition represents a span of reports or a partial view of a report,a user can view the data.
• If you specify a script when creating a OTBL table definition, you can passparameters when selecting data. Use this SELECT command formatSELECT table_columns FROM table_definition_nameWHERE '$runparam'='parameter1,parameter2,…'
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
• Data is in report 1F0
• Create a table named "Shoes"
• Expose columns:– "Item Number", "Qty", "Type", "Gender", "Siz"
• Do not expose columns:– "Color", "Unit Cost"
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
Right now the table is only available to users in your department.
Click "Yes" if you wish to make it available to other departments.
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
We selected departments 8 and 22.
Click "OK".
Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data
"Shoes" table has been created.
Click "Cancel" to exit the OTBL script.
• Your "table" of BIS data is now available for use with client tools, such as:
– Crystal Reports
– Microsoft Excel, Access
– Other tools that connect to ODBC data
Unisys ODBC Server – OTBL Script“Shoes" is now available
Manager
BIS Technology – A Pictorial
DTM
MRI
WebSphere MQ
MSG Queuing
• RDMS• DMS
Administrator
PCMEiceDrill
Developer
COBOLCOBOL
TIP, HVTIPTIP, HVTIP
Transactions
OperationalData
• Oracle• SQL Server• Sybase• ODBC• OLE DB
ICE
• Native Script• JavaScript
• Power Functions
Cache • User data
BISEngine
PCMAICEADMIN
Designer WorkbenchComponent
Builder
End User
EOM (DEPCON)
Printed Reports
SummarySummary
TM2200TM2200
OLTP
OtherBIS
DDVTELBIS Networking
ODBC Server
B2B B2C
XML SOAP
Mobile Computing
Java / J2EE
Frank’s SoapboxCool but little used BIS feature
Developer Workshop
Questions?
For technical questions or assistance on Business Information Server
Contact Unisys at any Time!
Frank Andrist+2711 233 [email protected]
Web Sites:eCommunity.unisys.comwww.unisys.com/biswww.serviceonline.unisys.comwww.unisys.com/customer-education