尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
How to transport PeopleSoft
Crystal reports to BI Publisher
reports via automation
Session Number 5276
March 27, 2018
Jay Murugan
Architect
DataTerrain
jmurugan@dataterrain.com
DataTerrain
& Oracle
DataTerrain has expertise on multiple Oracle products like Taleo,
Oracle Fusion HCM, PeopleSoft, Discoverer and Hyperion.
The following versions are specific to this presentation:
• PeopleSoft version 9.2
• OBIEE 11g and 12c
DataTerrain Overview
4
9 years in BI
Reports automation Silicon
Valley
based
Experienced and
Efficient team Oracle Gold
Partner
Why migrate to BI Publisher
Oracle has announced that PeopleSoft will end support for all Crystal Reports
following the end of Premier Support for 9.1 applications. Migrating to BI
Publisher has the following advantages:
• OBIEE is an enterprise reporting solution. And is available as on premise
solution as well as cloud-based reporting called BICS (Business Intelligence
Cloud service)
• Separate data logic, layout & translation
• BI Publisher can have multiple layouts for a single dataset, thereby reducing the
number of reports
• Users can view a report in interactive mode for lightweight analysis and generate
pixel-perfect reports
• You can create reports from virtually any data source with a JDBC connection.
• Provides Role-based security
5
Introduction to Automation
6
DataTerrain automation system converts both Datamodel and
Report components
Migration Approach
7
Analysis
Solution
Definition Migration Rollout
• Technical
• Functional
• Consolidation
• Complexity
• Project plan
• Environment
setup
• Proof of
concept
• Automated
migration
• Validation
• Issue Fixing
• Unit testing
• Transition to
Pre-Production
• UAT
• Migrate to
Production
Datamodel Automation
The following Datamodel features are part of conversion automation:
• Query
• Joins
• Parameters
• Computed/Formula Columns
• Command Query
• Separate Datasets for Subreports
• Dataset Links created for Subreports links
8
Report Automation
Crystal features are converted within few minutes by DataTerrain’s automation
system. The same in manual building takes hours or days.
• Tables(with Groups/Totals/Sub-Totals)
• Pivots
• Charts
• Formatting (Font/Number)
• Conditional Formatting
• Hyperlinks
• Page Layout properties/Dynamic fields in Header & Footer
• Static Filters
• Subreports
9
- The layouts can be
customised
(formats/header/footer etc.)
which be applied across all
reports
- Best Practices can be
incorporated in the tool
Process automation and DataTerrain
responsibilities – Crystal Reports
10
T6 Advantages
1. Speed - converts in minutes what would normally take hours or days for manual
conversion
2. Accuracy – Avoids human errors. Preserve years of efforts in design / development.
3. Consistency- Applies that same format/best practices across all the reports
4. Customizable – customized for specific features like Header/Logo etc.
5. Internal IT – Conserve internal team
6. Cost – DataTerrain offers fixed pricing model per report (fully functioning).
11
Questions?
Additional inquiries:
connect@dataterrain.com
650.701.1100
Complete your session survey!
• Open the HEUG Events App on your phone, tablet, or
laptop
• Click on this session in your schedule.
• Then click the "Resources" button and "Survey“
You will be required to login once with your Eventsential username
and password.
This presentation and all Alliance 2018 presentations are
available for download from the Conference site at
www.alliance-conference.com

More Related Content

Similar to How to transport PeopleSoft Crystal to BIP via automation_M.... (1).pptx

Murali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BIMurali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BI
Murali Tummala
 
Introduction to BizTalk for Beginners
Introduction to BizTalk for BeginnersIntroduction to BizTalk for Beginners
Introduction to BizTalk for Beginners
AboorvaRaja Ramar
 
Corporate overview 2017
Corporate overview 2017Corporate overview 2017
Corporate overview 2017
Jon Pyke FBCS CITP
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
MoumitaSarkar61
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
DhanshreeKondkar1
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
GentaSahuri2
 
bi-publisher.pptx
bi-publisher.pptxbi-publisher.pptx
bi-publisher.pptx
kjkombrink
 
COGNOS ANALYTICS
COGNOS ANALYTICSCOGNOS ANALYTICS
COGNOS ANALYTICS
Lesha Bhansali
 
ETL•Accelerator
ETL•AcceleratorETL•Accelerator
ETL•Accelerator
Trevido
 
otbioverviewow13-141008094532-conversion-gate01-converted.pptx
otbioverviewow13-141008094532-conversion-gate01-converted.pptxotbioverviewow13-141008094532-conversion-gate01-converted.pptx
otbioverviewow13-141008094532-conversion-gate01-converted.pptx
SreekumarSasikumar
 
Cognos CIO CEE 2010 Prague CZE
Cognos CIO CEE 2010 Prague CZECognos CIO CEE 2010 Prague CZE
Cognos CIO CEE 2010 Prague CZE
Stepan Kutaj
 
Info sphere overview
Info sphere overviewInfo sphere overview
Info sphere overview
Bhawani N Prasad
 
6. real time integration with odi 11g & golden gate 11g & dq 11g 20101103 -...
6. real time integration with odi 11g & golden gate 11g & dq 11g   20101103 -...6. real time integration with odi 11g & golden gate 11g & dq 11g   20101103 -...
6. real time integration with odi 11g & golden gate 11g & dq 11g 20101103 -...
Doina Draganescu
 
SPS Vancouver 2018 - What is CDM and CDS
SPS Vancouver 2018 - What is CDM and CDSSPS Vancouver 2018 - What is CDM and CDS
SPS Vancouver 2018 - What is CDM and CDS
Nicolas Georgeault
 
OTN EMEA TOUR 2016 - OBIEE12c New Features for End-Users, Developers and Sys...
OTN EMEA TOUR 2016  - OBIEE12c New Features for End-Users, Developers and Sys...OTN EMEA TOUR 2016  - OBIEE12c New Features for End-Users, Developers and Sys...
OTN EMEA TOUR 2016 - OBIEE12c New Features for End-Users, Developers and Sys...
Mark Rittman
 
Swati Gupta Resume
Swati Gupta ResumeSwati Gupta Resume
Swati Gupta Resume
Swati Gupta
 
Utilizing BI 11g Reporting To Get The Most Out of P6
Utilizing BI 11g Reporting To Get The Most Out of P6Utilizing BI 11g Reporting To Get The Most Out of P6
Utilizing BI 11g Reporting To Get The Most Out of P6
p6academy
 
KRISHNAVENI_GURRAM_CV
KRISHNAVENI_GURRAM_CVKRISHNAVENI_GURRAM_CV
KRISHNAVENI_GURRAM_CV
krishnaveni gurram
 
Migration to Oracle ERP Cloud: A must read winning recipe for all
Migration to Oracle ERP Cloud: A must read winning recipe for allMigration to Oracle ERP Cloud: A must read winning recipe for all
Migration to Oracle ERP Cloud: A must read winning recipe for all
Jim Pang
 
Amit_Kumar_CV
Amit_Kumar_CVAmit_Kumar_CV
Amit_Kumar_CV
Amit Kumar
 

Similar to How to transport PeopleSoft Crystal to BIP via automation_M.... (1).pptx (20)

Murali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BIMurali tummala resume in SAP BO/BI
Murali tummala resume in SAP BO/BI
 
Introduction to BizTalk for Beginners
Introduction to BizTalk for BeginnersIntroduction to BizTalk for Beginners
Introduction to BizTalk for Beginners
 
Corporate overview 2017
Corporate overview 2017Corporate overview 2017
Corporate overview 2017
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
 
BI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.pptBI MicrosoftMDM - Frank Olav Estensen.ppt
BI MicrosoftMDM - Frank Olav Estensen.ppt
 
bi-publisher.pptx
bi-publisher.pptxbi-publisher.pptx
bi-publisher.pptx
 
COGNOS ANALYTICS
COGNOS ANALYTICSCOGNOS ANALYTICS
COGNOS ANALYTICS
 
ETL•Accelerator
ETL•AcceleratorETL•Accelerator
ETL•Accelerator
 
otbioverviewow13-141008094532-conversion-gate01-converted.pptx
otbioverviewow13-141008094532-conversion-gate01-converted.pptxotbioverviewow13-141008094532-conversion-gate01-converted.pptx
otbioverviewow13-141008094532-conversion-gate01-converted.pptx
 
Cognos CIO CEE 2010 Prague CZE
Cognos CIO CEE 2010 Prague CZECognos CIO CEE 2010 Prague CZE
Cognos CIO CEE 2010 Prague CZE
 
Info sphere overview
Info sphere overviewInfo sphere overview
Info sphere overview
 
6. real time integration with odi 11g & golden gate 11g & dq 11g 20101103 -...
6. real time integration with odi 11g & golden gate 11g & dq 11g   20101103 -...6. real time integration with odi 11g & golden gate 11g & dq 11g   20101103 -...
6. real time integration with odi 11g & golden gate 11g & dq 11g 20101103 -...
 
SPS Vancouver 2018 - What is CDM and CDS
SPS Vancouver 2018 - What is CDM and CDSSPS Vancouver 2018 - What is CDM and CDS
SPS Vancouver 2018 - What is CDM and CDS
 
OTN EMEA TOUR 2016 - OBIEE12c New Features for End-Users, Developers and Sys...
OTN EMEA TOUR 2016  - OBIEE12c New Features for End-Users, Developers and Sys...OTN EMEA TOUR 2016  - OBIEE12c New Features for End-Users, Developers and Sys...
OTN EMEA TOUR 2016 - OBIEE12c New Features for End-Users, Developers and Sys...
 
Swati Gupta Resume
Swati Gupta ResumeSwati Gupta Resume
Swati Gupta Resume
 
Utilizing BI 11g Reporting To Get The Most Out of P6
Utilizing BI 11g Reporting To Get The Most Out of P6Utilizing BI 11g Reporting To Get The Most Out of P6
Utilizing BI 11g Reporting To Get The Most Out of P6
 
KRISHNAVENI_GURRAM_CV
KRISHNAVENI_GURRAM_CVKRISHNAVENI_GURRAM_CV
KRISHNAVENI_GURRAM_CV
 
Migration to Oracle ERP Cloud: A must read winning recipe for all
Migration to Oracle ERP Cloud: A must read winning recipe for allMigration to Oracle ERP Cloud: A must read winning recipe for all
Migration to Oracle ERP Cloud: A must read winning recipe for all
 
Amit_Kumar_CV
Amit_Kumar_CVAmit_Kumar_CV
Amit_Kumar_CV
 

Recently uploaded

Post init hook in the odoo 17 ERP Module
Post init hook in the  odoo 17 ERP ModulePost init hook in the  odoo 17 ERP Module
Post init hook in the odoo 17 ERP Module
Celine George
 
How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17
Celine George
 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
Frederic Fovet
 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
MJDuyan
 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Quiz Club IIT Kanpur
 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
Kalna College
 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
MattVassar1
 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
MattVassar1
 
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
biruktesfaye27
 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
roshanranjit222
 
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
220711130100 udita Chakraborty  Aims and objectives of national policy on inf...220711130100 udita Chakraborty  Aims and objectives of national policy on inf...
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
Kalna College
 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
Quizzito The Quiz Society of Gargi College
 
Creating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptxCreating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptx
Forum of Blended Learning
 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
khabri85
 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Kalna College
 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
Kalna College
 
Interprofessional Education Platform Introduction.pdf
Interprofessional Education Platform Introduction.pdfInterprofessional Education Platform Introduction.pdf
Interprofessional Education Platform Introduction.pdf
Ben Aldrich
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
Infosec
 
Observational Learning
Observational Learning Observational Learning
Observational Learning
sanamushtaq922
 
8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity
RuchiRathor2
 

Recently uploaded (20)

Post init hook in the odoo 17 ERP Module
Post init hook in the  odoo 17 ERP ModulePost init hook in the  odoo 17 ERP Module
Post init hook in the odoo 17 ERP Module
 
How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17How to Download & Install Module From the Odoo App Store in Odoo 17
How to Download & Install Module From the Odoo App Store in Odoo 17
 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
 
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx78 Microsoft-Publisher - Sirin Sultana Bora.pptx
78 Microsoft-Publisher - Sirin Sultana Bora.pptx
 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
 
Cross-Cultural Leadership and Communication
Cross-Cultural Leadership and CommunicationCross-Cultural Leadership and Communication
Cross-Cultural Leadership and Communication
 
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
Ethiopia and Eritrea Eritrea's journey has been marked by resilience and dete...
 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
 
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
220711130100 udita Chakraborty  Aims and objectives of national policy on inf...220711130100 udita Chakraborty  Aims and objectives of national policy on inf...
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
 
A Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by QuizzitoA Quiz on Drug Abuse Awareness by Quizzito
A Quiz on Drug Abuse Awareness by Quizzito
 
Creating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptxCreating Images and Videos through AI.pptx
Creating Images and Videos through AI.pptx
 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
 
Contiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptxContiguity Of Various Message Forms - Rupam Chandra.pptx
Contiguity Of Various Message Forms - Rupam Chandra.pptx
 
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
220711130083 SUBHASHREE RAKSHIT  Internet resources for social science220711130083 SUBHASHREE RAKSHIT  Internet resources for social science
220711130083 SUBHASHREE RAKSHIT Internet resources for social science
 
Interprofessional Education Platform Introduction.pdf
Interprofessional Education Platform Introduction.pdfInterprofessional Education Platform Introduction.pdf
Interprofessional Education Platform Introduction.pdf
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
 
Observational Learning
Observational Learning Observational Learning
Observational Learning
 
8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity8+8+8 Rule Of Time Management For Better Productivity
8+8+8 Rule Of Time Management For Better Productivity
 

How to transport PeopleSoft Crystal to BIP via automation_M.... (1).pptx

  • 1. How to transport PeopleSoft Crystal reports to BI Publisher reports via automation Session Number 5276 March 27, 2018
  • 3. DataTerrain & Oracle DataTerrain has expertise on multiple Oracle products like Taleo, Oracle Fusion HCM, PeopleSoft, Discoverer and Hyperion. The following versions are specific to this presentation: • PeopleSoft version 9.2 • OBIEE 11g and 12c
  • 4. DataTerrain Overview 4 9 years in BI Reports automation Silicon Valley based Experienced and Efficient team Oracle Gold Partner
  • 5. Why migrate to BI Publisher Oracle has announced that PeopleSoft will end support for all Crystal Reports following the end of Premier Support for 9.1 applications. Migrating to BI Publisher has the following advantages: • OBIEE is an enterprise reporting solution. And is available as on premise solution as well as cloud-based reporting called BICS (Business Intelligence Cloud service) • Separate data logic, layout & translation • BI Publisher can have multiple layouts for a single dataset, thereby reducing the number of reports • Users can view a report in interactive mode for lightweight analysis and generate pixel-perfect reports • You can create reports from virtually any data source with a JDBC connection. • Provides Role-based security 5
  • 6. Introduction to Automation 6 DataTerrain automation system converts both Datamodel and Report components
  • 7. Migration Approach 7 Analysis Solution Definition Migration Rollout • Technical • Functional • Consolidation • Complexity • Project plan • Environment setup • Proof of concept • Automated migration • Validation • Issue Fixing • Unit testing • Transition to Pre-Production • UAT • Migrate to Production
  • 8. Datamodel Automation The following Datamodel features are part of conversion automation: • Query • Joins • Parameters • Computed/Formula Columns • Command Query • Separate Datasets for Subreports • Dataset Links created for Subreports links 8
  • 9. Report Automation Crystal features are converted within few minutes by DataTerrain’s automation system. The same in manual building takes hours or days. • Tables(with Groups/Totals/Sub-Totals) • Pivots • Charts • Formatting (Font/Number) • Conditional Formatting • Hyperlinks • Page Layout properties/Dynamic fields in Header & Footer • Static Filters • Subreports 9 - The layouts can be customised (formats/header/footer etc.) which be applied across all reports - Best Practices can be incorporated in the tool
  • 10. Process automation and DataTerrain responsibilities – Crystal Reports 10
  • 11. T6 Advantages 1. Speed - converts in minutes what would normally take hours or days for manual conversion 2. Accuracy – Avoids human errors. Preserve years of efforts in design / development. 3. Consistency- Applies that same format/best practices across all the reports 4. Customizable – customized for specific features like Header/Logo etc. 5. Internal IT – Conserve internal team 6. Cost – DataTerrain offers fixed pricing model per report (fully functioning). 11
  • 13. Complete your session survey! • Open the HEUG Events App on your phone, tablet, or laptop • Click on this session in your schedule. • Then click the "Resources" button and "Survey“ You will be required to login once with your Eventsential username and password.
  • 14. This presentation and all Alliance 2018 presentations are available for download from the Conference site at www.alliance-conference.com
  翻译: