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

RightNow-OSC-ODBC0

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

RightNow-OSC-ODBC1

5. Launch the database expert

RightNow-OSC-ODBC2

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

RightNow-OSC-ODBC3

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"

RightNow-OSC-ODBC4

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

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
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
232x131_resourceimage
Getting Ahead of the Hybrid Data Curve
Read More
 
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More
 
232-132_How to Simplify Application Usage & Deployment with Microapps
How to Simplify Application Usage & Deployment with Microapps
Read More