The user-friendly interface for custom SQL reports.  No SQL query writing required.

SQL Server is a central part of the Microsoft data platform. Unfortunately, there is not a user-friendly interface that would allow end users to quickly access specific data sets or find data without knowing how to write SQL queries.

‍

Popdock democratizes the SQL reporting experience by allowing IT teams to control who has access to the data and providing a user interface for users to self-service.    

With Popdock, you can:

• View, query, filter and save favorite reports (lists or graphs) of data from your SQL environment
• Combine SQL data + data from other apps
• Use an intuitive to interface to add as many filters as you’d like
• Share data and reports with other people in your company that you don’t necessarily want logging into your SQL server
• Embed related SQL data in other apps

‍

Access the details, existing SQL Views, and share SQL data.

Not only can users create custom reports, but existing SQL views can also be made available.

The benefit of using your existing SQL views in Popdock is that there is an interface to work with the data and those lists can be accessed efficiently right along with all your other favorite reports. Users can create new favorites and there are several options built in to be able to share data:

• Create, share, and tag favorites within the Popdock web app
• Create, share, and tag favorites via Popdock widgets
• Export to Excel or PDF
• Schedule a job to email or send your report to Microsoft Teams or Slack
• Enable a Popdock API endpoint for your Popdock lists to programmatically use Popdock as a data source
• Do your formatting in Popdock and use Popdock data in Power BI or Tableau

‍

Combine SQL data with other data.

One of the most powerful features of Popdock is being able to combine data and add restrictions, variables, and calculation.  Join, merge, compare and summarize data across SQL tables and with other cloud and on-premise applications you use.  

‍

Some examples of combining Microsoft SQL data include:

‍

SQL + CRM + ERP Data:  

• Sales summaries with relationship manager (from CRM) by comparison date filters: daily sales, this month,year-to-date, this quarter, etc.
• ROI & spend related to campaigns
• Commission reporting

Exception Reports:

• Any place where data may be missing
• Data not integrated between SQL and your other apps

Legacy system data reporting

‍

Thinking about migrating SQL data?

Check out Popdock data lake management to take advantage of cost-effective data storage and access your data on going using Popdock. With a couple clicks, you can connect to any Popdock data source connectors and copy data as a CSV to a Microsoft Azure, Amazon Web Services S3, or Wasabi Data Lake.  

‍