cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Elena Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Jon-Heide Established Member
Established Member

Re: MySQL vs PostgreSQL with SSRS?

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 1
Highlighted
Jon-Heide Established Member
Established Member

Re: MySQL vs PostgreSQL with SSRS?

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.