Session Title

1
Reach Your Technical Peak 2004
2
Data to Enterprise Information!
3
Progress Reporting and BI Strategy

• To provide innovative solutions that will meet
  our customers demands for information delivery
  and enable them to maximize their profitability
  and efficiency by capitalizing on their
  investment in their Progress-based data assets.

4
OpenEdge BI View

• Two Functional Segments
• Operational Reporting
• Shows what is happening with operations
• Business Analytics
• Shows why indicators are at current levels

5
Progress BI Reporting
Complex
Complex
Simple
Simple
Data Analysis
Operational Reporting
6
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

7
Crystal Vision aligned with Progress
Complete Information Infrastructure
8
OpenEdge Reference Architecture
Where does Crystal fit in?
Users
Enterprise Services
Users
Enterprise Services
Crystal
Crystal
Integration Layer
Integration Layer
Presentation Layer
Presentation Layer
Service Interface and Environment Utilities
XML export / Open Client
BusinessWorkflows
Business Tasks
BusinessEntities
Data Access Services
Persistent Storage Services
Managed Data Store
Unmanaged Data Store
9
Analyzing Your Applications
A variety in integration options
10
Crystal 10
www.businessobjects.com/products/reporting
/crystalreports

• Whats New
• Edition Comparison
• Features
• Data Sheets
• Fact Sheets
• Developer Zone
• Training Courses
• Online Seminars, ILT eLearning

/crystalenterprise
11
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

12
The Basics

• SQL and 4GL are not the same
• Security
• Schemas
• Isolation Levels
• Statistics
• Index Hints

13
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

14
Connectivity Options
15
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

16
ODBC
Most common way of data access

• Install ODBC Drivers
• Configure Data Source
• Connect to OpenEdge SQL Engine

17
Using ODBC

• Windows
• ODBC Administrator to configure Data Source
• UNIX
• Set ODBC Driver environment variables
• Edit odbc.ini file to configure Data Source

18
ODBC Data Source Configuration
ODBC Data Source Administrator

• Add New Data Source

19
ODBC Data Source Configuration
ODBC Data Source Administrator

• Add New Data Source
• Select Driver

20
ODBC Data Source Configuration
ODBC Data Source Administrator

• Add New Data Source
• Select Driver
• Configure Data Source

21
Crystal Connectivity to Data Source
Using ODBC(RDO) option
22
Compatibility Matrix
Supported Configurations
Crystal 9 10 supports only SQL-92 so they can
only be used with Progress Version 9 or higher
Crystal 9 can be used against a Progress 8.3E
Database using ODBC SQL-89 with
CR90DBEXWIN_EN.ZIP hotfix
23
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

24
Using XML
TempTable, SDO or ProDataSet

• Progress Client or AppServer retrieves data

• Temp Table, SDO or ProDataSet

• Parsed to an XML file (or csv)

• Crystal Reports uses XML file

25
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

26
Using AppServer Open Client

• Progress Client calls Crystal

• Crystal calls AppServer using Open Client
• Java or .NET proxies

27
Summary of Connectivity Options
28
Agenda

• Introduction to Crystal 10
• Where to go for more information
• The Basics
• Connectivity Options
• ODBC
• XML
• AppServer Open Client
• Integration
• Crystal components available to Progress

29
Integration options
Implementation differs for CR, RAS and CE

• Crystal to Progress
• Data security
• Reuse 4GL business logic
• Progress to Crystal
• Refresh view reports
• Modify report layouts
• Let the user create layouts
• Web integration

30
Scalable for functionality
Java COM Modifyable reports
CE Explorer
Distribute Read-only reports
CE Pro
Relevance / Reliability
Ad-hoc web reporting
RAS
Standalone
Scalability Scheduling Security
CR Adv
CR Dev
Server Web
CR Pro
31
Integration Progress ? Crystal
Various client and server options
Progress App
32
Reference Materials

• Documentation - Crystal OpenEdge
• PSDN
• Open Client Proxy Code
• White Papers
• Knowledge Center
• DB security permissions

33
(No Transcript)