SQL:-RD has completed
the Certified for
Windows Server 2012
test and has met
SQL-RD is a Business Intelligence application for windows that saves time and money by making it easy to define single or packages of Microsoft® SQL Reporting Services reports, schedule and run them automatically, and send the reports to print, fax, disk, ftp, sms or email in a number of standard formats.
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, and more and who it should be sent to. SQL-RD provides a strong scheduling platform that has been designed to support a variety of reporting needs.
With SQL-RD it's easy to schedule 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.
SQL-RD helps you to respond to your business needs by setting schedules to run based on events rather than date. Add real-time monitoring to your SQL 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 present, an email is received, etc.
Automate SQL Reports by using a Dynamic Schedule to trawl through your database to find the parameter values to use and then generate and deliver a unique report for each value. Or bring enhanced Data-Driven functionality to your report distribution infrastructure. You can easily simplify management of your SQL reporting environment with the help of SQL-RD.
Once your schedule has been executed, why stop there? Use SQL-RD's unique 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.
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. SQL-RD can be a great help in automating reports, and offers a solid management environment to monitor and maintain your SQL reports.
The scheduling service runs as a desktop application, or as an Windows service. It will integrate with Exchange Server 5 (SP4) and above (2000 and 2003) or SMTP. Worried about Outlook security prompts? SQL-RD deals with these expertly - ensuring complete uninterrupted automation.
By automating repetitive reporting tasks, SQL-RD ensures that reports are created and distributed when needed, without error, and without costly support time.
Whether you're spending too much time running and distributing Reporting Services output to line managers, or you need to provide corporate management with tailored reports on a regular schedule, SQL-RD gives you the tools that you need.
|SQL-RD's comprehensive set of job (schedule) types gives you the power you need for any occasion.|
|Single Report Schedules|
|A single report is set to generate at specified intervals (Daily, Hourly, Weekly etc). It is exported to a specified format (PDF, Excel, XML etc). The exported file is delivered to one or more destinations (email, FTP, printer, etc). For example, email the daily sales report to the sales manager at 8am every week day except on public holidays.|
|Package Report Schedules|
|Set up a package of reports to be generated at defined intervals and delivered to one or more defined destinations - together. For example, a monthly report pack (consisting of a number of reports) can be sent to a client with all reports attached to the single email or compressed into a single zip file, or merged into a single Excel workbook, or PDF file before delivery.|
|Write and execute simple or complex business process automation scripts or macros using SQL-RD's Custom Tasks. Use this schedule on its own, or as part of a more complete automation solution. Examples include Send an email, Update a database record, Upload to FTP, Update a file, Print files and lots more.|
|Multiple instances of the same report are exported. For each instance SQL-RD will automatically enter the required parameter values, export the report and deliver the results to the corresponding email, folder, ftp, printer or fax. The parameters and destination are read from your own database. For example, run the same report for dozens of clients without writing a schedule for each client.|
|Dynamic Package Schedules|
|Dynamically generate and deliver individualized export packages for multiple recipients using the same set of reports. Dynamic Schedules for Packages! For example, you can use the same set of reports to generate individual monthly report packages for all your clients.|
|Instantly respond to business and client needs. Fire off reports or automation scripts when a defined system event occurs. For example, trigger a report or automation script when a value in a database has changed, or when a new email arrives You can even use values in the email body text to populate parameters, email addresses, database tables and more.|
|String a number of Event-Based schedules together as a batch to run in a specified order and/or at specified scheduled times. Use to ensure that required conditions are fulfilled before a report is exported. For example, run the report once a month, but only if the monthly total figure in the sales database matches that in the invoices database.|
|Expand Reporting Services functionality! Drive all variables of your reporting requirements (parameters, destinations, output format, etc) from database tables and queries.
Up | Scheduling Frequencies | Output Formats | Destinations | Custom Tasks | Event-Based Triggers | Scalability & Admin
|No other automation tool provides the huge array of frequencies that SQL-RD makes available at your fingertips.|
|Repeat every x days. For example, repeat ever 2 days will run the schedule every other day.|
|Every Week Day|
|Schedules will not run on Saturday and Sunday.|
|Repeat every x weeks. Choose the days too. For example run every 2 weeks on Monday, Wednesday and Saturday.|
|Repeat every x months. Specify only certain months. Also choose special days of the month. For example, run on the last Friday of every month except March.|
|Schedules run annually on a given date.|
|Create your own calendars for custom frequencies. For example. 4-4-3|
|Schedules will not run on these dates. Use the built in public holidays or select your own custom "do not run" dates. For example, do not run on New Year's Day.|
|Schedules will run when an event occurs. For example, Database record is modified, Database record is created, Unread email is present, File is modified, Process exists.|
|Repeat schedules at regular intervals. For example, Run every Tuesday at 8am and repeat the run every 30 minutes until 5pm.|
|Start & End Dates|
|Automatically set the schedule to begin on a given date, repeat at the given interval, and end on a set date. For example, Start on 1 Jan 2008. Run every week day until 31 March 2008.
Up | Schedule Types | Output Formats | Destinations | Custom Tasks | Event-Based Triggers | Scalability & Admin
|With more output formats, and enhanced formatting & manipulation options than any other Reports scheduling tool, SQL-RD gives you the flexibility to satisfy your formatting requirements with ease.|
|Character Separated (CSV)|
|MS Excel (XLS)|
|MS Word (DOC)|
|Other available formats|
Up | Scheduling Frequencies | Schedule Types | Destinations | Custom Tasks | Event-Based Triggers | Scalability & Admin
|Flexible, highly customizable and function-rich destination functionality..|
|SMS (Cell phone Text)|
|Other Destination Options|
Up | Scheduling Frequencies | Output Formats | Schedule Types | Custom Tasks | Event-Based Triggers | Scalability & Admin
|Give yourself greater control by using SQL-RD's Custom Tasks to create automation scripts. Use them as a complete automation process in automation schedules, or to provide additional enhancement as part of report export schedules.|
|Additional Report Schedules Task Actions|
|Available Custom Tasks|
|Respond instantly to business and client needs by firing off reports and automation scripts when an event occurs. SQL-RD gives you a list of triggers to suit any occasion. All the triggers below can run if the condition is True or if the condition is False.|
|Database Record Exists|
|Apply to new database records only, or to any matching database records.|
|Database Record Has Been Modified|
|Choose to include New (Inserted) records and Deleted records. Use this for follow-ups by selecting to only match the condition if the record has been (or not been modified) in x minutes. Repeat the action every x minutes until the condition is no longer true, or run just once.|
|Unread Mail Is Present|
|Monitor a POP or IMAP mailbox for new emails. Forward or Redirect. Delete mail after processing. Read the body text and other mail sections (sender email, subject, etc) and use the values to populate report parameters, email addresses etc. For example, send the report to the sender of the email.|
|Use this trigger to respond to the existence of a new file in a local or network folder.|
|File Has Been Modified|
|Great for monitoring log files, but works equally well for all other types of local or network files.|
|Other Event Triggers|
Up | Scheduling Frequencies | Output Formats | Destinations | Custom Tasks | Schedule Types | Scalability & Admin
|Beyond its basic functionality, you want to know that SQL-RD can extend its capabilities to satisfy your needs as your business demands grow. Below is a brief list of some of the functionalities which put SQL-RD (and you) years ahead of the market.|
Up | Scheduling Frequencies | Output Formats | Destinations | Custom Tasks | Event-Based Triggers | Schedule Types
|Minimum recommended: P4 750MHz/ 500MB disk space/ 1G memory.|
|PC Type: Desktop, Server, Virtual Machine|
|Operating System: Windows NT4 SP6a, Windows 2000, Windows 2000 Server, Windows XP, Windows 2003 Server, Windows Vista|
|SQL Server Reporting Services: SQL-RD is supported for RS 2005, 2008, 2008 R2 and 2012; Both Standalone and Sharepoint Integrated modes are supported.|
|Other Software Requirements: Download full pre-requisites list.|
|SQL-RD Version 7.0 Full Feature 30-Day Evaluation Edition|
|SQL-RD End User License Agreement|
|SQL-RD End User License Agreement (Editable)|
|SQL-RD User Manual|
|SQL-RD Pre-Requisites Document|