How to use DB2/other data storage as data source in SSRS.

709    Asked by KobayashiSasaki in SQL Server , Asked on Nov 20, 2019
Answered by Prateek Jain

SSRS by default comes up with lots of data source drivers. Still list is very less, if we compare it with PowerBI, SSRS has very less data source drivers which are available as default option. So, in order to connect to DB2 or any other data source which is not a default option in SSRS, we should download its relevant ODBC or OLEDB drivers.

Like DB2 is IBM product, you can download the drivers from either the website of specific vendor or Microsoft also provides certain drivers. IBM provides OLE DB .net provider which can be used to connect with SSRS as well. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.swg.im.dbclient.adonet.doc/doc/c0061396.html

Once downloaded and install, these drivers can be enabled as an option in the data source list provided by SSRS.



Your Answer

Interviews