Скачать презентацию 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 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 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 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 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 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 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 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 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 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 § 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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. 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® 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 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 © 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 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 § 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 © 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 © 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 © 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 © 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 © 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 © 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 © 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 © 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 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 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 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 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 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 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 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 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 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 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 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 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 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 < 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

Web Services - WSA 58 DEV-30 Integrating Business Objects and your Open. Edge Application 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 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 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 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 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 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 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 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 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 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 + - 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 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 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 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 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 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

77 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software 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 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 • 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 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 ? 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 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 83 DEV-30 Integrating Business Objects and your Open. Edge Application © 2008 Progress Software Corporation