Toad Data Point

Toad Data Point offers a suite of training and support resources tailored for new users, ensuring a smooth onboarding experience and effective utilization of the tool's capabilities.

Training Resources:

1. Free Self-Paced Web-Based Training

Quest Software provides a complimentary, self-paced online course titled "Toad Data Point – Getting Started." This course is designed for users of version 3.0 or later and covers:

• Benefits of using Toad Data Point

• Basic product workflows

• Overview of key features

The course includes a knowledge check test to reinforce learning. While a certificate of completion is not currently available, the course serves as a solid foundation for new users.

2. User Guides and Documentation

Comprehensive user guides are available, detailing functionalities such as:

• Connecting to various data sources

• Writing and executing SQL queries

• Automating tasks and scheduling

• Data import/export procedures

These guides are instrumental for users seeking in-depth understanding of Toad Data Point's features.

3. Community Forums and Blogs

The Toad World community offers forums and blogs where users can:

• Engage with other Toad Data Point users

• Seek answers to specific questions

• Share experiences and best practices

This collaborative environment fosters continuous learning and problem-solving. Toad World Blog

4. Video Tutorials

A range of video tutorials is available, covering topics such as:

• Introduction to Toad Data Point Professional Edition

• Simplifying data preparation

• Utilizing the Workbook interface

These visual resources cater to different learning preferences and enhance understanding of the tool's functionalities.

Support Services:

1. Knowledge Base

The Quest Support Portal houses a comprehensive knowledge base, offering solutions to common issues, best practices, and technical articles to assist users in troubleshooting and optimizing their use of Toad Data Point.

2. Technical Support

For more personalized assistance, users can contact Quest's technical support team. Support is available for licensed users, and trial users have access to support for 30 days from the registration date.

3. Licensing Assistance

Questions regarding licensing can be directed to the Software Licensing team via email at [email protected]. They provide guidance on licensing options, renewals, and other related inquiries.

Toad Data Point incorporates a suite of security measures to safeguard sensitive data during access, analysis, and sharing. These measures encompass encryption protocols, authentication mechanisms, secure data sharing practices, and rigorous software integrity controls.

Encryption and Data Protection:

• Master Password Encryption: Users can set a master password to encrypt stored connection credentials, adding an extra layer of security to prevent unauthorized access to saved passwords.

• FIPS-Compliant Cryptography: Toad Data Point employs cryptographic algorithms that conform to the Federal Information Processing Standards (FIPS), ensuring robust protection for sensitive data both in transit and at rest.

• Encrypted ZIP Archives: When automating tasks, users have the option to create password-protected and encrypted ZIP files, utilizing 128-bit or 256-bit encryption to secure exported data.

Authentication and Access Control:

• Authentication Keys in Toad Intelligence Central (TIC): TIC utilizes authentication keys to manage access to data objects:

  • Personal Authentication Keys: Require individual users to provide their own credentials for data access.

  • Shared (Public) Keys: Allow multiple users to access data objects using predefined credentials, facilitating collaborative work while maintaining security.

• Role-Based Access Control: Administrators can define user roles and permissions within TIC, ensuring that users have appropriate access levels to data and functionalities.

Software Integrity and Security Practices:

• Code Signing and Software Integrity: All Toad Data Point releases are digitally signed using Quest's code signing certificates. This process verifies the authenticity of the software and ensures that it has not been tampered with since signing.

• Vulnerability and Penetration Testing: Quest conducts regular security assessments, including Static Application Security Testing (SAST), Dynamic Application Security Testing (DAST), and annual third-party penetration tests, to identify and remediate potential vulnerabilities.

• Malware Scanning: Before release, all software builds undergo thorough malware scanning, and SHA-256 checksums are provided to verify the integrity of installation files.

Toad Data Point, developed by Quest Software, provides functionalities that support data ownership and portability, particularly when used in conjunction with Toad Intelligence Central (TIC). Here's an overview:

Data Ownership:

Local Storage: When you save data to your local storage in Toad Data Point, the data remains private and accessible only to you. This ensures full control over your datasets without external access.

Toad Intelligence Central (TIC): Publishing data to TIC allows for broader sharing within your organization. You can define sharing settings to keep data private, share with specific users or groups, or make it public within TIC. Users with "Manage" privileges can modify sharing options, refresh schedules, and other settings.

Static Datasets: When publishing data from sources like Excel or Access to TIC, the data is stored as a static snapshot. Changes in the original source files do not automatically reflect in TIC unless the dataset is refreshed.

Data Portability:

Export Options: Toad Data Point supports exporting data in various formats, including Excel, CSV, and SQL scripts. This facilitates easy data transfer and integration with other tools or platforms.

Automation and Scheduling: You can automate data exports and schedule regular refreshes of datasets in TIC. This ensures that shared data remains up-to-date and reduces manual intervention.

Data Compare Projects: Toad Data Point allows saving and sharing of Data Compare projects (*.dcp files). These files can be shared with other users, provided they have the necessary connections defined, promoting collaborative data analysis.

The terms and conditions for contract renewal and cancellation of Toad Data Point, developed by Quest Software, vary based on the type of license—Perpetual or Subscription. Below is a detailed overview:

Renewal Terms:

Perpetual Licenses with Maintenance

• Maintenance Period: Typically spans one year from the date of the first invoice. toad-for-mysql.

• Renewal Process: Maintenance agreements automatically renew for another 12 months unless either party provides written notice of cancellation at least 60 days before the renewal date. toad-data-modeler.

• Reinstatement After Lapse: If maintenance lapses, reinstatement requires payment of all past maintenance fees plus a reinstatement fee equal to 25% of the annual maintenance fee.

Subscription (Term) Licenses:

• Automatic Renewal: Subscriptions automatically renew for additional periods equal to the expiring subscription term or one year (whichever is shorter), unless either party gives notice of non-renewal at least 30 days before the end of the current term.

• Pricing Adjustments: Any pricing increase for the renewal term will not exceed 7% of the pricing for the applicable service in the immediately prior term, unless specified otherwise in the Order Form.

• Renewal Coordination: For term license renewals, it's recommended to coordinate directly with your designated Toad account manager.

Cancellation and Termination:

• Perpetual Licenses: You may terminate the license by providing 30 days' prior written notice to Quest.

• Subscription Licenses: To prevent automatic renewal, provide written notice of non-renewal at least 30 days before the end of the current subscription term.

• Termination for Cause: Either party may terminate the agreement for cause if the other party breaches the agreement and fails to cure the breach within 30 days of receiving written notice.

• Post-Termination Obligations: Upon termination, you must immediately cease use of the software and certify in writing within 30 days that all copies have been destroyed or returned to Quest.

Payment and Penalties:

• Payment Terms: Payments are due within 30 days from the date of the applicable invoice.

• Late Payments: Overdue amounts may accrue interest at 1.5% per month or the maximum rate permitted by law, whichever is lower.

• Service Suspension: If any amount is 30 or more days overdue, Quest may suspend services until the amount is paid in full, after providing at least 7 days' prior notice.

Toad Data Point, developed by Quest Software, incorporates several features and practices to support compliance with various data security and accessibility standards. Here's an overview:

Security and Compliance Features

• TLS 1.2+ Support: Starting from version 5.5, Toad Data Point mandates the use of TLS 1.2 or higher for secure connections to MySQL data sources, enhancing data transmission security.

• LDAP Integration: Version 6.4 introduces LDAP capabilities within SingleStore, facilitating secure authentication and aiding in compliance with organizational security policies.

• Role-Based Access Control: Through integration with Toad Intelligence Central, Toad Data Point offers role-based access control, enabling organizations to manage user permissions effectively and maintain data integrity.

• Data Profiling and Cleansing: The software provides tools for data profiling, transformation, and cleansing, ensuring data accuracy and consistency, key aspects of data governance and compliance.

Accessibility and Government Standards:

• Section 508 Compliance: Quest Software invests resources to ensure its products, including Toad Data Point, comply with Section 508, which mandates accessibility for individuals with disabilities.

• Federal Standards Alignment: The U.S. Department of Veterans Affairs requires that the use of Toad Data Point aligns with NIST standards, including Federal Information Processing Standards (FIPS), indicating the software's capability to meet stringent federal compliance requirements.