SQL Server Reporting Services
by Microsoft
SQL Server Reporting Services still delivers paginated reports by email and file share in many companies. The REST API v2.0 lists reports, folders, shared data sources, subscriptions with their last run status and schedules. Bringing that catalog into the Lake shows which deliveries fail, which data sources point to retired servers and what a move to newer BI must carry over.
- Category
- Cloud & Data Platforms
- Type
- BI & reporting
- Interface
- OData API
- Built with
- Connect Any API
- Credentials
- Vendor credentials, Username and password
02Data
What you can sync.
- Reports
- Folders
- Data sources
- Subscriptions
- Schedules
Put SQL Server Reporting Services reports next to revenue and usage, so every cost has an owner and a reason.
Need more? Name any other SQL Server Reporting Services data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- Other credentials
- A username and password
SQL Server Reporting Services uses other credentials or a username and password. You add the credentials once, when the AI asks for them, and it tells you where to create them in Microsoft if you need help.
04Questions
Questions you can answer.
Once SQL Server Reporting Services data is in your Lake, ask an AI Mind in plain words or build the answer in DataPrism BI.
- Which subscriptions failed on their last run, and who stopped receiving reports?
- Which reports use shared data sources pointing to servers scheduled for decommission?
- Which folders contain reports not modified in two years?
- How many subscriptions deliver to external email addresses?
05How it works
How it works in DataMind.
-
Pick SQL Server Reporting Services.
Open Lake, pick SQL Server Reporting Services in the source picker and name the connection. Connect Any API opens with a ready prompt that points the AI at the SQL Server Reporting Services API docs.
-
Answer a few questions.
The AI reads the SQL Server Reporting Services documentation, then asks which credentials you will use, which data to sync (for example reports and folders), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
It builds the connector, tests it and shows you sample rows. Then SQL Server Reporting Services data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
06Pairs
Works well with SQL Server Reporting Services.
Sources teams join with SQL Server Reporting Services in the Warehouse, each one connected the same way.
