1 / 30

Business Information Server Integrating the World

Business Information Server Integrating the World. Frank Andrist Systems Analyst. Topics. ICE / BIS object ODBC. Happy 40 th Birthday!. MAPPER / BIS. iceDrill.

hall-reynolds
Download Presentation

Business Information Server Integrating the World

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Information Server Integrating the World Frank Andrist Systems Analyst

  2. Topics • ICE / BIS object • ODBC

  3. Happy 40th Birthday! MAPPER / BIS

  4. 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

  5. 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 onappropriate data. • You can also build complex calculations, produce subtotals based on intervals for selectedfields, and reformat and resort filtered data sets into tabular reports. • Perform a series of tasks with one click of your mouse using predefined queries associatedwith 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.

  6. Data-Source1 Data-Source2 Data-Source n … Management Reporting

  7. iceDrill

  8. 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

  9. 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.

  10. 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)

  11. ODBC serves up your BIS data fast and easy.

  12. Unisys ODBC Server – Overview • 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 32 Bit client only

  13. 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,…'

  14. 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"

  15. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  16. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  17. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  18. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  19. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  20. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data

  21. 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.

  22. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data We selected departments 8 and 22. Click "OK".

  23. Unisys ODBC Server – OTBL ScriptCreate a "Table" from existing data "Shoes" table has been created. Click "Cancel" to exit the OTBL script.

  24. Unisys ODBC Server – OTBL Script“Shoes" is now available • 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

  25. BIS Technology – A Pictorial Developer Administrator • • Native Script • JavaScript • Power Functions Manager BISEngine Cache • User data OtherBIS B2B B2C End User Designer Workbench Component Builder WebSphere MQ • Oracle • SQL Server • Sybase • ODBC • OLE DB • RDMS • DMS Java / J2EE MSG Queuing PCMA ICEADMIN PCME iceDrill OperationalData MRI Mobile Computing Printed Reports EOM (DEPCON) Summary ODBC Server Transactions DTM ICE OLTP COBOL XML SOAP DDVTEL TIP, HVTIP BIS Networking TM2200

  26. Frank’s Soapbox Cool but little used BIS feature

  27. Developer Workshop

  28. Questions?

  29. Contact Unisys at any Time! • Web Sites: • eCommunity.unisys.com • www.unisys.com/bis • www.serviceonline.unisys.com • www.unisys.com/customer-education For technical questions or assistance on Business Information Server • Frank Andrist • +2711 233 4023 • Frank.Andrist@za.Unisys.com

More Related