Forum Discussion
MySQL vs PostgreSQL with SSRS?
I'm setting up a Redmine server and I'd like to write SSRS reports against it, looks like I can do either PostgreSQL or MySQL for the database, does anyone know whether one or the other is easier to connect to with SSRS?
Thanks.
SSRS will support any OLE-DB or ODBC based connector. I believe both mysql and postgress have OLEDB + ODBC options. From the SSRS perspective, it will just see them either of them as "generic" connections, so you'll get a basic query editor and no advanced parameterization options.
1 Reply
SSRS will support any OLE-DB or ODBC based connector. I believe both mysql and postgress have OLEDB + ODBC options. From the SSRS perspective, it will just see them either of them as "generic" connections, so you'll get a basic query editor and no advanced parameterization options.