DEV-30: Integrating Business Objects® and Your Open. Edge® Application Brandon Gibbs Manager, US Solution Engineers
Agenda § BO/Crystal/Xcelsius® product overviews § BO/Crystal Open. Edge Data § Open. Edge applications BO/Crystal 2 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Xcelsius - http: //www. xcelsius. com § Xcelsius Engage • An intuitive desktop application designed to create flash-based data presentations and dashboards from many sources (Excel, DB’s, etc. ) Development Time § Run Time Xcelsius Engage Server (includes Engage and…) • Integration kits for Adobe® Live. Cycle Data Services, IBM® Websphere®, Microsoft® Share. Point, and Reporting Services • Flynet Web Services generator 3 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Xcelsius Example 4 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Xcelsius Example COPYRIGHT © 2007 BUSINESS OBJECTS S. A. ALL RIGHTS RESERVED. 5 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Scalable for Functionality Crystal Reports 2008 / Business Objects XI 3. 0 ala Sc lity bi CR Server CR 2008 Java™, . NET™ & COM SDKs 6 Max 20 CAL Server provides: - Web Access - Scheduling - Security DEV-30 Integrating Business Objects and your Open. Edge Application BO Enterprise Professional Add-on: Live Office © 2008 Progress Software Corporation
Agenda § BO/Crystal/Xcelsius product overviews § Crystal Open. Edge Data § Open. Edge applications Crystal 7 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Connection Options 9 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC Most common way of data access Crystal Reports SQL statement Resultset OE SQL engine Crystal Server Client Server 10 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC Most common way of data access § Works with all Crystal products § Easiest to implement ad-hoc option § Most flexible approach § Re-implement data security and logic in SQL § ODBC install and configure on each client Wizard usable in all scenarios – more details can be found at: http: //www. psdn. com/library/kbcategory. jspa? category. ID=1417 11 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 12 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 13 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 14 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 15 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 16 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 17 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 18 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 19 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 20 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 21 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 22 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 23 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 24 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 25 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 26 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ODBC 27 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Open. Edge Reference Architecture O D Business B C Enterprise Services (XML Export / Open Client) Business Services Data Access OE SQL OE ABL Data Sources 28 DEV-30 Integrating Business Objects and your Open. Edge Application Common Infrastructure Presentation Crystal © 2008 Progress Software Corporation
ADO. NET (XML) Most simple way to reuse business logic & security Crystal Reports® CRServer/ BO Ent XML Open. Edge App. Server™ Client Server 29 Temp. Table Pro. Data. Set™ DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET (XML) Most simple way to reuse business logic & security § Some overhead § Usable in 2 -tier, 3 -tier and 4 -tier § Only Push from ABL (no scheduling) § Limited or no ad-hoc option 30 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET (XML) 31 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Open Client Most elegant way of integration Crystal Reports CR Server/ Open Client BO Ent Open Java /. NET Client Java /. NET Temp. Table Pro. Data. Set Client Server App. Server proxy. p TTitem. p 32 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Open Client Most elegant way of integration § 100% Open. Edge Reference Architecture § Usable in 3 -tier and 4 -tier (App. Server req. ) § Usable without Open. Edge application push! § ADO. NET implements Pro. Data. Set § Java client implements Temp-Table NEW in Open. Edge 10. 1 A - can use Pro. Data. Set! 33 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 34 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 35 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 36 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 37 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 38 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 39 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 40 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
ADO. NET Example 41 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 42 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 43 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 44 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 45 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 46 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 47 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 48 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 49 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 50 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 51 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 52 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Java / Temp Table Example 53 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services - Get. Orders. P DEFINE TEMP-TABLE Order. Details FIELD Order. Num LIKE Order. Num FIELD Sales. Rep LIKE Order. Sales. Rep FIELD Order. Date LIKE Order. Date FIELD Ship. Date LIKE Order. Ship. Date FIELD Total. Dollars AS DECIMAL FIELD Order. Status LIKE Order. Status. DEF INPUT PARAMETER i AS INTEGER. DEFINE OUTPUT PARAMETER TABLE FOR orderdetails. FOR EACH Order WHERE Order. Cust. Num = i: CREATE Order. Details. ASSIGN Order. Details. Order. Num = Order. Num Order. Details. Sales. Rep = Order. Sales. Rep Order. Details. Order. Date = Order. Date Order. Details. Ship. Date = Order. Ship. Date Order. Details. Order. Status = Order. Status. END. 55 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services - WSDL <? xml version="1. 0" encoding="UTF-8"? > <wsdl: definitions name="Order. Info" target. Namespace="urn: Open. Edge. Services: Order. Info " xmlns: tns="urn: Open. Edge. Services: Order. Info “. . . <wsdl: documentation>Author=Brandon, Encoding. Type=DOC_LITERAL, Proxygen_Product=Progress Version 10. 1 A</wsdl: documentation> <wsdl: types>. . . <schema element. Form. Default="qualified" target. Namespace="urn: Open. Edge. Services: Order. Info " xmlns="http: //www. w 3. org/2001/XMLSchema">< complex. Type name="get. Order. Details_Order. Details. Row "><sequence><element name=" Order. Num" nillable="true" type="xsd: int"/><element name="Sales. Rep" nillable="true" type="xsd: string"/><element name="Order. Date" nillable="true" type="xsd: date"/><element name="Ship. Date" nillable="true" type="xsd: date"/><element name="Total. Dollars" nillable="true" type="xsd: decimal"/><element name="Order. Status" nillable="true" type="xsd: string"/></sequence></complex. Type><complex. Type name="get. Order. Details_Order. Details. Param "><sequence><element max. Occurs="unbounded" min. Occurs="0" name="Order. Details. Row" type="S 2: get. Order. Details_Order. Details. Row"/></sequence></ complex. Type><element name="get. Order. Details"><complex. Type><sequence><element name=" i" nillable="true" type="xsd: int"/></sequence></complex. Type></element><element name="get. Order. Details. Response"><complex. Type><sequence><element name="result" nillable="true" type="xsd: string"/><element name="Order. Details" nillable="true" type="S 2: get. Order. Details_Order. Details. Param"/></sequence></ complex. Type></element></schema> </wsdl: types> 56 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services - WSDL. . . <Author>Brandon</Author><Service>asbroker 1</Service>< Work. Dir>C: Open. EdgeWRK</Work. Dir> <Web. Services. Client>true</Web. Services. Client><User. Defined. App. Service>true</User. Defined. App. Service>. . . </PGGen. Info> <Deployment. Wizard> <Soap. Endpoint. URL>http: //localhost: 8080/wsa/Order. Info</ Soap. Endpoint. URL> <Web. Service. Namespace user. Defined="true">urn: Open. Edge. Services: Order. Info </Web. Service. Namespace> </Deployment. Wizard> <Name>Order. Info</Name><Pro. Path>c: openedgewrk</Pro. Path> <Name>get. Order. Details</Name><Pro. Path>c: openedgewrk</Pro. Path><Proc. Ext>p</Proc. Ext> <Name>result</Name><Type>1</Type><Mode>0</Mode></ Return. Value><Parameter ordinal="1"> <Name>i</Name><Type>4</Type><Mode>1</Mode></Parameter><Parameter ordinal="2"> <Name>Order. Details</Name><Type>15</Type><Mode>2</Mode> <Meta. Data><Field. Name>Order. Num</Field. Name><Type. Name>integer</Type. Name></Meta. Data> <Meta. Data><Field. Name>Sales. Rep</Field. Name><Type. Name>character</Type. Name></Meta. Data> <Meta. Data><Field. Name>Order. Date</Field. Name><Type. Name>date</Type. Name></Meta. Data> <Meta. Data><Field. Name>Ship. Date</Field. Name><Type. Name>date</Type. Name></Meta. Data> <Meta. Data><Field. Name>Total. Dollars</Field. Name><Type. Name>decimal</Type. Name></Meta. Data> 57 <Meta. Data><Field. Name>Order. Status</Field. Name><Type. Name>character</Type. Name></Meta. Data> DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services - WSA 58 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 59 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 60 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 61 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 62 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 63 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 64 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 65 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 66 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Web Services 67 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Data Connectivity Options Summary ODBC XML ADO Java. NET + + Pull + - Ad-hoc ++ - - - Business. Logic/ Security reuse Config/deploy -- + ++ ++ - + +- +- 234 34 34 2 -tier/3 -tier/4 -tier 68 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Agenda § BO/Crystal/Xcelsius product overviews § Crystal Open. Edge Data § Open. Edge Apps Crystal 69 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Integration Open. Edge Crystal Various client and server options COM CR OCX Viewer ASP/JSP CR RDC Open. Edge Creation App URL CR Server / BO Ent CSP CR OCX WS Designer Client Server 70 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
What Do You Want to Offer? § Run completely locally or with App. Server § Auto generate reports, feed parameters § Use ODBC, XML or Open Client § View in Active. X window § Print to printer locally or on server § Export to PDF, Word, Excel, XML, HTML § ? ? ? 71 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
URL Syntax § Very loosely coupled interface § Viewrpt. asp (. csp pre release 10) § URL Parts: • • 75 id = CMS Object ID apsuser, apspassword, apsauthtype init = Viewer Type promptex cmd; export_fmt; export_opt = Export Options sf = Selection Formula gf = Group Selection Formula DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Example URL’s – View and Refresh § http: //nbbgibbs/businessobjects/viewrpt. cwr? id=152&apsuser=administrator &apspassword=Pr 0 gr 3$$&apsauthtype=sec. E nterprise&cmd=export&export_fmt=u 2 fpdf: 0 § <same as previous, except last line> &promptex-emp. Start=10&promptex. My. Param=My own report header &init=actx: connect 76 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
77 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
78 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Conclusion Many options exist – which to choose? § Data access § 79 • ODBC for easiest ad-hoc and other cases • XML or Open Client Java Bean / ADO. NET for best re-use of business logic Integration • Use CR Server if possible – grow path to Business Objects Enterprise • Active. X or DHTML/Browser to view DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Business Intelligence Exchange Sessions § Monday • OPS-6 Beginners Guide on Open. Edge SQL via ODBC or JDBC § Wednesday • OPS-27 Understanding Record and Table Locking In Open. Edge SQL Applications • DEV-34 Get to Know Your Data – Open Source Data Integration, Business Intelligence and more 80 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
? Questions 81 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Thank You 82 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
83 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation
Скачать презентацию DEV-30 Integrating Business Objects and Your Open Edge
30bdc937a87b220197a27c5760f808d9.ppt