Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 91
  • Last Modified:

Data source in SSRS

Hello,

I was able to built a report using SSDT 2015 tools connecting to Oracle database but I need to publish this report in SSRS 2014 (SQL Server Express Advanced Services 2014) . I tried to create a shared datasource in SSRS to connect to oracle database. the only option that is available is Microsoft SQL Server. (Please see attached). Is this because I installed an express SQL server version?

What do I need to do to so I could get the other data types like ODBC, Oracle Server, Flat files etc...
DataSource.PNG
0
angel7170
Asked:
angel7170
2 Solutions
 
Dung DinhDBA and Business Intelligence DeveloperCommented:
Yes, I think so. Please refer the link https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx#Reporting

SQL Server Express Advanced Services 2014 does not support Remote and non-SQL data source support. Even it only supports connect to SQL Express Edition.
0
 
ManjuIT - Project ManagerCommented:
SQL Express connects only to SQL. upgrade your version to have other options as well.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now