Get more from Toad Data Point... with onsite training

Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:

  • Access almost any source from a single tool
  • Visually drag and drop to create SQL queries
  • Profile, transform and cleanse data easily
  • Automate frequent reporting tasks

Use these links below to learn more about the most popular Toad Data Point topics!


Getting Started



Mastering
Connectivity

Writing
Queries

Import/Export


Automation

Community Discussion

Danny Torres
Follow / 14 Sep 2016 at 7:04pm / Toad Data Point
Latest post by on 10 May 2017 at 6:59pm

How to get the most out of this forum – Best practices for what information...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post: - Product...

The better a problem is described, the better the assistance tends to be.

In order to better assist with your issue at hand, please include the following information in your initial post: 

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below) 

Create Support Bundles

You can create a support bundle and send it to Dell Support or to the Toad Data Point community Web site (peer-to-peer support). The support bundle provides information (about your application and the database) that is used to help troubleshoot problems. 

Select Help | Support Bundle. It may take time for Toad to generate the support bundle depending on your system configuration.
The file name of the generated support bundle is ToadSupportBundleToad Data Point.zip.

 

Create Support Bundle for a SQL Query Issue

If your issue is a SQL query or cross-connection query issue, it is helpful if additional log files are included in the support bundle. These log files are automatically included if you generate a support bundle immediately after executing the query in either the Editor or Query Builder.

Use the following procedure to ensure that the SQL log files are generated and included in the support bundle. These additional log files (proxy.log located in the DataHubSupportBundle.zip and SQLAnalyze.log) are important to assist Support in troubleshooting the issue.

For issues related to SQL or cross-connection query optimization, use the following procedure as well. These logs are also helpful for optimization issues.

 

To create a support bundle for a SQL query or cross-connection query issue

In the Editor or Query Builder, reproduce the error or issue.

After reproducing the error, immediately select Help | Support Bundle to generate a support bundle.

Toad asks if you want to log the row count for each table used in the query. If you select Yes, Toad determines the size of each table used in the query. This adds additional time to the generation process, but also provides additional information about your issue.

When Toad is finished generating the support bundle, attach it.

Note: For best results, always send the entire support bundle.

 

*Note: Please refrain from including private data in your posts

Be as thorough as you can with the provided info. We will reply to you as quick as possible.

We are glad to assist you.

 Latest Release Information:

 This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features.  This way you can stay as informed as possible:

 -          What’s New Section (why they would want to pay attention to this new version)

-          http://documents.software.dell.com/toad-data-point/4.0/release-notes/release-notes/new-features

 -          Link to Download & Documentation

-          https://support.software.dell.com/toad-data-point/4.0

-          Link to Trial

-          https://software.dell.com/register/54955/

 -          Overview of new feature(s) (with link to the release notes)

http://documents.software.dell.com/toad-data-point/4.0/release-notes/release-notes/new-features

http://documents.software.dell.com/toad-data-point/4.0/release-notes/

 

 Top 5 Knowledge Base Articles:

 On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.

 This month’s Top Knowledge Base Articles

1. This month’s Top Knowledge Base ArticlesVideo - Making Effective Use of Data with Toad Data Point (195645)

https://support.software.dell.com/toad-data-point/kb/195645

 2. Common Oracle connection problems (7712)

https://support.software.dell.com/toad-data-point/kb/7712

 3. Error, "ORA-12170: TNS:Connect timeout occurred" when connecting to Oracle (105610)

https://support.software.dell.com/toad-data-point/kb/105610

 4. Error connecting to database after installing on Windows 64-Bit OS: "ORA-12154" (12495)

https://support.software.dell.com/toad-data-point/kb/12495

 5. "ERROR [08001] [IBM] SQL30081N A communication error has been detected." when connecting to DB2 (47041)

https://support.software.dell.com/toad-data-point/kb/47041

Feel free to browse them. Remember to sign in to your account to view.

 

4359 4 / Create an account to join the discussion.
Mike Triplett
Follow / 26 Jul 2017 at 4:52pm / Toad Data Point Beta Program
Latest post by on 23 Feb 2018 at 5:55pm

Toad Data Point Beta 4.3.0.253 (32 bit) - Job Manager does not wo...

Expand content
I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks. I saw a suggest to upgrade to...

I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks.  

I saw a suggest to upgrade to the Beta to see if it fixes my problem.  I've installed Toad Data Point Beta 4.3.0.253 (32 bit) and that does not fix the error.

This is the error I receive when attempting to "Schedule" a "Automation".

Exception: (1,1306):WnfStateChangeTrigger:

I've also tried changing to Task Scheduler 1.0 and that fails also.

377 2 / Create an account to join the discussion.
barr2014
Follow / 23 Feb 2018 at 3:46pm / Toad Data Point

Possible loop needed

Expand content
Hi all! I am new to the forum and new to Toad Data Point. I have written a query that I am having trouble finishing. My query identifies overstocked item/locations and understocked item/locations and matches...

Hi all! I am new to the forum and new to Toad Data Point. I have written a query that I am having trouble finishing. My query identifies overstocked item/locations and understocked item/locations and matches them up together in order to send merchandise from one location to another. The issue I am having is figuring out some type of loop process to determine which stores to send the items to. I need my query to first look at stores within the same district, then move onto stores within the same state, then move onto stores within the same region. For the stores in the same region I want it to order by who can take the most units. All while adding the quantity of the receiving stores as it goes until it fulfills all of the quantity from the sending store.

Example: Item 123 at Store A has 156 units it needs to transfer out. Store A is in district 307, in Virginia, in region 8796. Below are the results for the stores than need item 123.

I need the query to result that store 'I' can take the merchandise first at 24 units (same district). Then 'G' at 12 units, then 'H' at 12 units, then 'J' at 6 units (same state). Then 'K' at 40 units, then 'B' at 35 units, lastly at 'C' for 27 units (to sum to the total of 156 units).

STORE DISTRICT STATE REGION QTY
B 206 MD 8796 35
C 1338 NY 8796 30
D 206 MD 8796 18
E 927 FL 8796 6
F 1675 ME 8796 6
G 330 VA 8796 12
H 311 VA 8796 12
I 307 VA 8796 24
J 311 VA 8796 6
K 206 MD 8796 40

I have been wracking my brain and looking at examples and cannot figure out where to start? Multiple case statements? Separate queries that create an order?

Any help will be greatly appreciated.

Unanswered 48 0 / Create an account to join the discussion.