SQL-RD について

SQL Server Reporting Services(SSRS)のレポートの自動スケジューリングと配信

SQL-RD makes it easy to automate SQL Server Reporting Services (SSRS) Reports. Simply define a single, or packages, of SSRS Reports, set the schedule and automatically send reports to print, fax, folder, FTP, SMS, DropBox, Sharepoint and email, in a number of standard formats including Excel, Word, PDF and RPT. By automating repetitive reporting tasks, SQL-RD - SSRS Data Driven Automation - ensures that reports are created and distributed when needed, without error, and without costly support time.

SQL-RD Features

  • Easy To Use - Simply set up a "schedule" stating how often you would like each report to run, whether you'd like the output in Word, Excel, HTML, RTF, Acrobat, RPT, text format etc and who it should be sent to. SQL-RD will do the automated delivery for you, delivering reports to folder, email, printer, fax, DropBox, Sharepoint, FTP or SFTP.
  • Date and Time Scheduling - It's easy to schedule SSRS Reports to run at a specific date and time, or to run them hourly, daily, weekly, or monthly or set up your own custom frequencies e.g. 4-4-3, every other day, third Monday of the month, and so on. And the same report can be scheduled to be run multiple times with different parameters, formats, frequencies, and destinations. It makes SSRS Reports scheduling simple, hassle-free and convenient for you.
  • Event Triggers - Distribute SSRS Reports and respond to your business needs by setting schedules to run based on events and triggers rather than date. Add real-time monitoring to your SSRS Reports distribution process with SQL-RD's Event Based Schedules, reports are fired off when events occur e.g. database value is present, file is modified, window is open, an email is received, etc. SQL-RD makes sure the reports are created and distributed on time and error-free.
  • Dynamic and Data Driven - Use SQL-RD's Dynamic and Data-Driven Schedule processes to trawl through your database to find the parameter values to use and then generate and deliver a unique report for each value. Bring advanced Data-Driven functionality to your SSRS reports distribution infrastructure. And with Bursting Schedules you can quickly and easily burst out and deliver report groups to different recipients and destinations. Manage your SSRS Reports distribution needs with greater effectiveness, speed, and efficiency.
  • Pre and Post Delivery Automation - Use SQL-RD's Custom Actions to run another program, enter values in a database, modify a file and lots more. Or use Automation Schedules for general business process automation without scheduling any reports at all.
  • Intuitive Interface - SQL-RD's familiar Explorer-like interface makes it easy to define and schedule report packages. The context (right-click) menus and full copy-and-paste support make it easy to create complex distribution schedules.
  • Windows Service Scheduler - The scheduling service runs as a desktop application, or as a windows service. It will integrate with Exchange Server, Office 365 or SMTP. Worried about Outlook security prompts? SQL-RD deals with these expertly - ensuring complete uninterrupted automation.

Business Benefits

  • Quick to set up and simple to use.
  • Minimize and eliminate repetitive tasks and manual processes.
  • Reduce costs and cut labor by automating business processes and reports from one application.
  • Improve customer satisfaction through mass personalized distribution.
  • Reliable data, and compliance, through automated report generation.
  • Time and cost savings through streamlined business process automation and SSRS Reports distribution.
  • Leverages existing investments in hardware, software, email and other applications.
  • Low training and implementation costs.
  • Low Total Cost of Ownership.

Whether you're spending too much time running and distributing SSRS Reports output to line managers, or you need to provide corporate management with tailored reports on a regular schedule, SQL-RD gives you the SSRS Reports scheduling tools that you need.