Currently working with Telerik reporting . how to Bind the MongoDB database collection to the Telerik Reporting ?
Thanks, vrushali
Neli
Telerik team
commented on 06 Jun 2022, 09:41 AM
Hi Vrushali,
In Telerik Reporting, we use data source components to retrieve and use data in the report. We do not have a specific data source component for connecting to NoSQL databases like MongoDB, but there are two components that can be used to retrieve data from a MongoDB database. These components are the WebServiceDataSource component and the ObjectDataSource component.
The WebServiceDataSource component enables data items to display data located on a service in JSON format, while using no code. If you already have a REST API that you use to retrieve data from your MongoDB database, then you can use that API with this component to connect to MongoDB through it. If you are interested in using this component, I recommend you to have a look at the Connecting to Google Books APIs KB article which demonstrates how one may use this component to connect to an endpoint that returns data.
The other option is the ObjectDataSource component. With ObjectDataSource, you can use any .NET driver or any other approach to read the data into a .NET object and wrap the retrieved data into an ObjectDataSource. This component gives a lot of freedom in how you will retrieve your data and what you will do with it but it also comes at the price of being a little harder to set up(mainly for security reasons) and also required more work from your side - Connecting the ObjectDataSource component to a Data Source.
I hope that you will find the provided information to be useful, please do not hesitate to let me know if you have any other questions or need further assistance.
Hi Vrushali,
In Telerik Reporting, we use data source components to retrieve and use data in the report. We do not have a specific data source component for connecting to NoSQL databases like MongoDB, but there are two components that can be used to retrieve data from a MongoDB database. These components are the WebServiceDataSource component and the ObjectDataSource component.
The WebServiceDataSource component enables data items to display data located on a service in JSON format, while using no code. If you already have a REST API that you use to retrieve data from your MongoDB database, then you can use that API with this component to connect to MongoDB through it. If you are interested in using this component, I recommend you to have a look at the Connecting to Google Books APIs KB article which demonstrates how one may use this component to connect to an endpoint that returns data.
The other option is the ObjectDataSource component. With ObjectDataSource, you can use any .NET driver or any other approach to read the data into a .NET object and wrap the retrieved data into an ObjectDataSource. This component gives a lot of freedom in how you will retrieve your data and what you will do with it but it also comes at the price of being a little harder to set up(mainly for security reasons) and also required more work from your side - Connecting the ObjectDataSource component to a Data Source.
I hope that you will find the provided information to be useful, please do not hesitate to let me know if you have any other questions or need further assistance.