Migrating Oracle Service Cloud (RightNow) ODBC to Crystal Reports and other tools

Migrating Oracle Service Cloud (RightNow) ODBC to Crystal Reports and other tools

November 04, 2014 0 Comments

To facilitate the migration from the deprecated MySQL ODBC interface to RightNow, or Oracle Service Cloud (OSC) - DataDirect Cloud has added real-time direct SQL connectivity using the secure public APIs over HTTPS. We know what we’re doing after introducing standards based SaaS connectivity to Salesforce.com back in 2006. I’m starting with Crystal Reports, but similar steps apply to the following popular tools:

  • Tableau
  • Qlikview
  • Spotfire
  • Microstrategy
  • SSIS
  • Linked Server
  • Pentaho
  • Talend
  • Alteryx
  • Birst

Getting started connecting Crystal Reports 2013 to Oracle Service Cloud (RightNow)

1- Create Datadirect Cloud Login to start your trial

2- Create data source in DataDirect Cloud connecting to your Oracle Service Cloud instance


3. Download and install 32-bit DataDirect Cloud ODBC client (JDBC clients and OData production are also supported); and create an ODBC data source named “RightNow32” for Oracle Service Cloud from step 2 that is local to the Crystal Reports machine.

4. Launch Crystal Reports 2013 and create a blank report


5. Launch the database expert


6. Select “RightNow32” ODBC data source and navigate the schema.


7. Your data will be in the RIGHTNOW schema and you will notice tables and stored procedures. Tables are the OSC entities or objects; and procedures expose your native reports. If you have more than 8000, check out SAP article to display them all titled, "1215994 - Unable to see all database objects in Crystal Reports"


8. You will notice that the OSC interface in DataDirect Cloud is ANSI SQL-92 compliant with standard ODBC escape syntax, and you can find a list of supported scalar functions for Oracle Service Cloud (RightNow) in our documentation.

I’m a data hippie and love standards and interoperability. But if you have reports hard coded against MySQL specific commands, please let us know of any challenges you’re facing.

Got any questions RightNow, or maybe later?

1. Start a trial of DataDirect Cloud OData production at DataDirect Cloud. 2. Talk to us @DataDirect_News or @SAsInSumit 3. Or call 1-800-876-3101 to learn more


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. 

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
ProgressNEXT: Premier Event for Modern Application Development
Read More
Getting Started with Kinvey
Read More
Low-Code Platforms: What Developers Think and Why
Read More