Home Services Partners Company
DataDirect Oracle Relational Database connectivity to 11g with SSRS 2008 saves the day

DataDirect Oracle Relational Database connectivity to 11g with SSRS 2008 saves the day

June 28, 2011 0 Comments

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:

  • Do you want to support Oracle 11g and newer versions going forward?
  • Do you want to support failover in your Oracle RAC Grid environment?
  • Is Oracle database security important to your organization?
  • Is improved SSRS performance important to your business users?

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??

Oracle Report Server Credentials

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 Sakar

Sumit Sarkar

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. 

Read next JDBC-ODBC Bridge Replacement Yields 310% Performance Boost
Comments
Comments are disabled in preview mode.