Connect Crystal Reports to MongoDB

Connect Crystal Reports to MongoDB

Posted on April 15, 2016 0 Comments

This guide will walk you through connecting SAP Crystal Reports to a MongoDB DataSet.

We recently had a tutorial rumble where we put our heads together and brainstormed ways we could help you, our loyal customers, best utilize our solutions.

SAP Crystal Reports is the de facto standard in reporting. I have been a user of Crystal Reports on and off during my nearly 20 year career in software, mostly connecting to relational data sources like MS SQL and Oracle.

I have had more and more customers expressing interest in connecting Crystal Reports to MongoDB using ODBC. This inspired me to whip up a quick and easy walkthrough documenting the process of reporting against MongoDB using the Progress ODBC Driver for MongoDB.

Note: This guide assumes you have MongoDB installed with the “Restaurants” MongoDB Data Set. The “Restaurants” MongoDB Data Set can be found here.

Connecting SAP Crystal Reports to a MongoDB DataSet Using DataDirect

  1. Determine whether your version of Crystal Reports is 32bit or 64bit. Then, download + install the corresponding free 15 day trial of the DataDirect for MongoDB ODBC driver.
  2. Navigate to the Progress DataDirect for ODBC Installation Directory and click on the ODBC Administrator
  3. Click on User or System DSN and click Add
  4. Click Add

  5. Select DataDirect 8.0 MongoDB
  6. Configure the Data Sources by filling out a Data Source Name, the Host Name, Port Number, and which Database within MongoDB you want to connect to (you may chose to leave this blank if you prefer). The Schema Definition Path will be automatically generated for you.
  7. Configure Data Sources

  8. Click on Test Connect and ensure that your connection is established
  9. Launch SAP Crystal Reports
  10. Select ‘Report Wizard’
  11. Select Report Wizard

     
  12. Select ‘Create New Connection’ -> ODBC (RDO) -> 'Make New Connection' in the Available Data Sources Window
  13. Make New connection

  14. Select your 32bit MongoDB Data Source Name
  15. Select Source Name

  16. Select Finish
  17. Select the MongoDB tables you to use for your report
  18. Select the Tables

  19. You can now see your selected tables in Crystal Reports!
  20. Next, select the fields from your MongoDB you’d like to use in your Crystal Report
  21. Select Fields

  22. Click Next and select how you would like to group and summarize your data within your report (optional). The Grouping window will look like the below.
  23. Group and Name

  24.  The Summaries window will look like the below
  25. Grouping

  26. Finally, select the template you would like to use for your report and select Finish
  27. Select Template

  28. We now can see and utilize our MongoDB Data within Crystal Reports
  29. We can now see and use MongoDB data

Your turn!

At this point, you should have access to all your MongoDB data from the familiar interface of Crystal Reports, and you’ve done it with the proven performance of Progress DataDirect. If that’s not true—what are you waiting for? Head to our website to see the full suite of DataDirect connectors and start integrating!

Please feel free to ask any questions, share your experience using this guide, or even request another data connectivity quick start. I can be reached at mcoutsof@progress.com and you can follow me on twitter at https://twitter.com/DataSherpa.

Michael Coutsoftides

As a Principal Solutions Engineer at Progress Data Direct, Michael eats, sleeps and breathes data connectivity. He is dedicated to developing and implementing proven, high-performance data connectivity solutions, empowering enterprises to better manage and integrate data across Big Data, Cloud and Relational data sources. Follow him at https://twitter.com/DataSherpa

Comments

Comments are disabled in preview mode.
Topics

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

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

Loading animation