From working with several Microsoft BI environments, it has come to my attention that there is no native support for Oracle 11g with SQL Server Reporting Services (SSRS) 2008. The "Oracle Relational Database" data source you are using today extends System.Data.OracleClient which has been deprecated, and Microsoft recommends that you use a third-party Oracle provider. And like several of our customers realized, you too may be running an unsupported configuration in your production BI environment.
Key questions you need to answer:
If you answered "yes" to any of these questions, Progress DataDirect is ready to save the day with increased performance and full support of Oracle 11g (and future versions) in your Oracle SSRS Reporting environment through our exclusive support of SSRS 2008 to Oracle. In working with Microsoft Professional Support Services, it is recommended to switch to Progress DataDirect to support the Oracle 11g Grid. You paid for Oracle functionality and maintenance, so why not use it??
How do we do it? DataDirect has developed a Built-in Reporting Services Data Processing Extension (DPE) for Oracle powered by our high performance wire protocol Connect for ADO.NET Oracle provider. This enables support for core functionality of the report server, that is extensible by Microsoft, such as storing credentials. Without the DPE assembly, you are looking at a potentially disastrous security risk because the database password will be stored in plain text. This is simply not an option.
The preliminary steps are:
1. Download a free trial today of the Connect for ADO.NET Oracle provider.
2. Review the knowledge article to obtain and configure the Data Processing Extension for Oracle SSRS: http://progresscustomersupport-survey.force.com/ConnectKB/articles/Article/9502. (Certification of the DPE assembly is on our roadmap, and you should contact us for the latest status)
3. Try to stay humble while saving the day.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.