Connection between JasperStudio and MongoDB

Question

I tried connecting mongodb to Japerstudio using the MongoDb connection option and the JDBC Option by following some tutorials. The MongoDB option is not even able to connect to the Database using the connection string. The JDBC Option is not able to recognize the JDBC Driver, I even added the JDBC jar file to Libraries accordingly. Can someone guide me to the detail, how to make a stable connection between mongodb and JasperStudio?

Finally, I somehow able to connect to my local mongodb and tried to make reports on data using queries. The queries i am performing are sometimes not even accepted and sometimes even though they are accepted, It is only showing reports by pasting raw data over the pages and not helping in anyway by making the data usable to work (like making charts,graphs,etc). when i accessed the data i tried to add some fields in mongodb to the chart, but it is only able to add it in json format and unable to make it a good visual representation.

Example:

{
    'collectionName':'Employee',
    'findFields':{
    'details': {
      $elemMatch: {
        'department': 'IT',
        'subdept": "software",
        'leave_period': {
          $gte:"2023-08-05T09:00:00Z",
          $lte:"2023-08-10T20:00:00Z"
        }
      }
    }
  }
}

if i use the above query, i expect it to show the results between given dates. but it is not showing any data at all. can someone guide me how to even do this, if that is possible?

Answer 1

You need to allowlist the IPs for the JasperStrudio. Find the IPs and add the same in this way