SQL Deluxe 2.0

posted by Smoke Ranch Software - 6/10/2018
Smoke Ranch Software Active Since 8/9/2006
United States

reviews Ask a Question



Write interactive reports, run and save SQL scripts, view query results with automatic sorting and paging, and more. Designed for the developer who wants to use SQL to write custom reports without having to create a custom DNN module. Module 38216
  • $49.95 Standard
  • $79.95 Plus Source
  • $124.95 Enterprise Edition
  • $154.95 Enterprise + Source

$49.95

Add To Cart

Discounts

  Get a 50.0% discount on SQL Deluxe 2.0 (Standard) when you order SQL Deluxe 1.4 (Standard)
  Get a 50.0% discount on SQL Deluxe 2.0 (Enterprise Edition) when you order SQL Deluxe 1.4 (Enterprise Edition)
  Get a 50.0% discount on SQL Deluxe 2.0 (Plus Source) when you order SQL Deluxe 1.4 (Plus Source)
  Get a 50.0% discount on SQL Deluxe 2.0 (Enterprise Plus Source) when you order SQL Deluxe 1.4 (Enterprise Plus Source)
Features

Querying and Reporting
  • Compatible with DNN 7.2.2 and above, including DNN 8x and DNN 9x.
  • Compatible with SQL Server 2000 and above.
  • Save and manage your SQL scripts.
  • Create interactive, parameterized reports — allow the user to enter data which will be dynamically inserted as parameters to your SQL queries.
  • Automatic sorting and paging.
  • Export any report to Excel (CSV format).
  • Automatic Tokens — insert tokens into your SQL code to dynamically represent common values, such as the current User ID or the current Portal ID. These tokens are automatically replaced with the correct values when the SQL is executed.
  • Interactive Tokens — insert tokens into your SQL code to represent a value that must be supplied by the user through a TextBox, ListBox, or Drop Down List. Lists can have set values or pull from the database.
  • Connect to multiple databases. The module allows you to define multiple connections, and then specify the desired connection to use for a given report, or when running ad-hoc queries.
  • Optional integration with the Smoke Ranch Ad Banner Manager allows targeted ads to be served based on user-entered data supplied to an interactive report.
Report Formatting
  • Specify css styles for column headers, rows, alternating rows, and paging controls.
  • Add a custom header or footer to each report using text/HTML.
  • Ability to embed HTML in your query means you can dynamically format individual cells.
Security
  • Protection against SQL injection attacks -- interactive reports use parameterized queries, rather than concatenation of SQL.
  • Restrict access to reports based on DNN user role.
  • Optionally force data to be viewed only over a secure SSL connection (HTTPS).
Requirements
  • DNN 7.2.2+/8x/9x
  • SQL Server 2000+
Additional Features
screenshots




 

Product License

Smoke Ranch Software, LLC grants you a non-exclusive, non-transferable right to use this module on your DNN) installation. Each DNN installation requires a single Production License. A DNN installation is defined as a single DNN database which can host multiple child portals. These portals may have their own unique web addresses, but they are managed from a single DNN host. You must purchase one additional Production License for each extra DNN installation. The Enterprise Edition of this product allows you to install and use this product on unlimited DNN installations, but these DNN installations must be owned by the same entity (an individual or organization).

Smoke Ranch Software, LLC grants you a non-exclusive, non-transferable right to use this module on your DNN installation.
Each DNN installation requires a single Production License.
A DNN installation is defined as a single DNN database which can host multiple child portals.
These portals may have their own unique web addresses, but they are managed from a single DNN host.
You must purchase one additional Production License for each extra DNN installation.
The Enterprise Edition of this product allows you to install and use this product on unlimited DNN installations, but these DNN installations must be owned by the same entity (an individual or organization).
End User License Agreement
For Smoke Ranch SQL Deluxe
Revised March 20, 2018
Copyright © 2018 Smoke Ranch Software, LLC. All rights Reserved.
IMPORTANT: READ CAREFULLY:
This Smoke Ranch Software, LLC End User License Agreement (“EULA”) is a legal agreement between you (either an individual or a single entity) and Smoke Ranch Software, LLC for the Smoke Ranch Software, LLC materials accompanying this EULA, which may include computer software, associated media, printed materials, and “on line” or electronic documentation (“Software”). BY INSTALLING, COPYING OR OTHERWISE USING THE SOFTWARE, YOU AGREE TO BE BOUND BY THE TERMS OF THIS EULA. IF YOU DO NOT AGREE TO THE TERMS OF THIS EULA, DO NOT INSTALL, COPY OR USE THE SOFTWARE.
SOFTWARE PRODUCT LICENSE
The Software is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. Smoke Ranch Software, LLC or its suppliers own the title, copyright and other intellectual property rights in the Software (excluding the DotNetNuke Portal Engine which is an Open-Source project). The Software is licensed, not sold. Specific License Grant.
1. GRANT OF LICENSE.
Smoke Ranch Software, LLC grants you the rights described in this EULA provided that you comply with all the terms and conditions of this EULA:
· General License Grant. Smoke Ranch Software, LLC grants you a non-exclusive, non-transferable right to use this module on your DotNetNuke(DNN) installation. Each DNN installation requires a single Production License. A DNN installation is defined as a single DNN database which can host multiple child portals. These portals may have their own unique web addresses, but they are managed from a single DNN host. You must purchase one additional Production License for each extra DNN installation. The Enterprise Edition of this product allows you to install and use this product on unlimited DNN installations, but these DNN installations must be owned by the same entity (an individual or organization). The Enterprise Edition license further grants you the right to distribute software within licensees organization and subsidiary companies, but not Franchisee, Parent, or Peer companies without the express written consent of Smoke Ranch Software, LLC.
· Documentation. With respect to electronic and other documentation, you may make any number of copies (either in hard copy or electronic form) provided that such copies shall be used only for internal purposes and are not republished or distributed beyond your premises.
· Reservation of Rights. Smoke Ranch Software, LLC reserves all rights not expressly granted herein.
2. DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS.
· Limitations on Reverse Engineering, Decompilation, and Disassembly. You may not reverse engineer, decompile, or disassemble the Software, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation.
· Rental. You may not rent, lease, or lend the Software without express written permission from Smoke Ranch Software, LLC.
· Termination. Without prejudice to any other rights, Smoke Ranch Software, LLC may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of the Software and all of its component parts.
· Consent to Use of Data. You agree that Smoke Ranch Software, LLC and its affiliates may collect and use technical information gathered as part of the product support services provided to you, if any, related to the software. Smoke Ranch Software, LLC may use this information solely to improve our products or to provide customized services or technologies to you. Smoke Ranch Software, LLC may disclose this information to others but not in a form that personally identifies you.
3 SOFTWARE MAINTENANCE/UPDATES.
Smoke Ranch Software, LLC is not obligated to provide maintenance, technical support or updates to you for the Software. However, Smoke Ranch Software may, in its sole discretion, provide technical support, updates and/or supplements of the Software and/or related information (“Updates”) to you hereunder, in which case such Updates shall also be deemed to be included in the “Software” and therefore governed by this EULA, unless other terms of use are provided by Smoke Ranch Software, LLC with such Updates.
4. EXPORT RESTRICTIONS.
You acknowledge that the Software is subject to U.S. export jurisdiction. You agree to comply with all applicable international and national laws that apply to the Software, including the U.S. Export Administration Regulations, as well as end-user, end-use and destination restrictions issued by U.S. and other governments.
5. INTELLECTUAL PROPERTY RIGHTS.
All title and intellectual property rights in and to the Software; including but not limited to any images, photographs, animations, video, audio, music, text and “applets” incorporated into the Software and any copies of the Software that you are expressly permitted to make herein, are owned by Smoke Ranch Software, LLC or its suppliers. All title and intellectual property rights in and to the content which may be accessed through use of the Software are the property of the respective content owner and may be protected by applicable copyright or other intellectual property laws and treaties. This EULA grants you no rights to use such content. All rights not expressly granted are reserved by Smoke Ranch Software, LLC.
6. DISCLAIMER OF WARRANTIES.
TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, Smoke Ranch Software, LLC AND ITS SUPPLIERS PROVIDE THE SOFTWARE AND ANY (IF ANY) SUPPORT SERVICES AS IS AND WITH ALL FAULTS, AND HEREBY DISCLAIM WITH RESPECT TO THE SOFTWARE AND SUPPORT SERVICES ALL WARRANTIES AND CONDITIONS, WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING, BUT NOT LIMITED TO, ANY (IF ANY) WARRANTIES, DUTIES OR CONDITIONS OF OR RELATED TO: MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, LACK OF VIRUSES, ACCURACY OR COMPLETENESS OF RESPONSES, RESULTS, WORKMANLIKE EFFORT AND LACK OF NEGLIGENCE. ALSO, THERE IS NO WARRANTY, DUTY OR CONDITION OF TITLE, QUIET ENJOYMENT, QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION OR NON-INFRINGEMENT. THE ENTIRE RISK AS TO THE QUALITY, OR ARISING OUT OF THE USE OR PERFORMANCE OF THE SOFTWARE AND ANY SUPPORT SERVICES, REMAINS WITH YOU.
7. EXCLUSION OF INCIDENTAL, CONSEQUENTIAL AND CERTAIN OTHER DAMAGES.
TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL SMOKE RANCH SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, SPECIAL, INCIDENTAL, INDIRECT, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES WHATSOEVER (INCLUDING, BUT NOT LIMITED TO, DAMAGES FOR: LOSS OF PROFITS, LOSS OF CONFIDENTIAL OR OTHER INFORMATION, BUSINESS INTERRUPTION, PERSONAL INJURY, LOSS OF PRIVACY, FAILURE TO MEET ANY DUTY (INCLUDING OF GOOD FAITH OR OF REASONABLE CARE), NEGLIGENCE, AND ANY OTHER PECUNIARY OR OTHER LOSS WHATSOEVER) ARISING OUT OF OR IN ANY WAY RELATED TO THE USE OF OR INABILITY TO USE THE SOFTWARE OR SUPPORT SERVICES, THE PROVISION OF OR FAILURE TO PROVIDE SUPPORT SERVICES, OR OTHERWISE UNDER OR IN CONNECTION WITH ANY PROVISION OF THIS EULA, EVEN IN THE EVENT OF THE FAULT, TORT (INCLUDING NEGLIGENCE), STRICT LIABILITY, BREACH OF CONTRACT OR BREACH OF WARRANTY OF Smoke Ranch Software, LLC OR ANY SUPPLIER, AND EVEN IF Smoke Ranch Software, LLC OR ANY SUPPLIER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. BECAUSE SOME STATES/JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.
8. LIMITATION OF LIABILITY AND REMEDIES.
NOTWITHSTANDING ANY DAMAGES THAT YOU MIGHT INCUR FOR ANY REASON WHATSOEVER (INCLUDING, WITHOUT LIMITATION, ALL DAMAGES REFERENCED ABOVE AND ALL DIRECT OR GENERAL DAMAGES), THE ENTIRE LIABILITY OF Smoke Ranch Software, LLC AND ANY OF ITS SUPPLIERS UNDER ANY PROVISION OF THIS EULA AND YOUR EXCLUSIVE REMEDY FOR ALL OF THE FOREGOING SHALL BE LIMITED TO ACTUAL DAMAGES INCURRED BY YOU BASED ON REASONABLE RELIANCE UP TO THE GREATER OF THE AMOUNT ACTUALLY PAID BY YOU FOR THE SOFTWARE OR FIVE DOLLARS (US$5.00). THE FOREGOING LIMITATIONS, EXCLUSIONS AND DISCLAIMERS SHALL APPLY TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, EVEN IF ANY REMEDY FAILS ITS ESSENTIAL PURPOSE.
9. APPLICABLE LAW:
If you acquired the Software in the United States, this EULA is governed by the laws of the State of Idaho. If the Software was acquired outside the United States, then local law may apply.
10. U.S. GOVERNMENT RIGHTS.
All Software provided to the U.S. Government pursuant to solicitations issued on or after December 1, 1995 is provided with the rights and restrictions described elsewhere herein. All Software provided to the U.S. Government pursuant to solicitations issued prior to December 1, 1995 is provided with RESTRICTED RIGHTS as provided for in FAR, 48 CFR 52.227-14 (JUNE 1987) or DFAR, 48 CFR 252.227-7013 (OCT 1988), as applicable.
11. LINKS TO THIRD PARTY SITES.
You may link to third party sites through the use of the Software. The third party sites are not under the control of Smoke Ranch Software, LLC, and Smoke Ranch Software is not responsible for the contents of any third party sites, any links contained in third party sites, or any changes or updates to third party sites. Smoke Ranch Software, LLC is not responsible for webcasting or any other form of transmission received from any third party sites. Smoke Ranch Software, LLC is providing these links to third party sites to you only as a convenience, and the inclusion of any link does not imply an endorsement by Smoke Ranch Software, LLC of the third party site.
12. ENTIRE AGREEMENT.
This EULA is the entire agreement between you and Smoke Ranch Software relating to the Software and the support services (if any) and it supersedes all prior or contemporaneous oral or written communications, proposals and representations with respect to the Software or any other subject matter covered by this EULA. To the extent the terms of any Smoke Ranch Software policies or programs for support services conflict with the terms of this EULA, the terms of this EULA shall control.
13. UPDATES.
Smoke Ranch Software, LLC may make updates and changes to this license agreement from time to time. Such changes will be posted on our website at http://www.SmokeRanch.com. Such changes or updates will become effective immediately. If you elect not to be bound by the new license agreement you must immediately destroy all copies of the Product and inform Smoke Ranch Software, LLC in writing.