DEV-30 Integrating Business Objects and Your Open Edge

Скачать презентацию DEV-30 Integrating Business Objects and Your Open Edge

30bdc937a87b220197a27c5760f808d9.ppt

Количество слайдов: 78

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

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

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

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

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

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= Web Services - WSDL < complex. Type name="get. Order. Details_Order. Details. Row "> 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. Web Services - WSDL. . . Brandonasbroker 1< Work. Dir>C: Open. EdgeWRK truetrue. . . http: //localhost: 8080/wsa/Order. Info urn: Open. Edge. Services: Order. Info Order. Infoc: openedgewrk get. Order. Detailsc: openedgewrkp result10 i41 Order. Details152 Order. Numinteger Sales. Repcharacter Order. Datedate Ship. Datedate Total. Dollarsdecimal 57 Order. Statuscharacter 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 § &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

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