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

andy.corson
Follow / 15 Feb 2018 at 3:21pm / Toad Data Point
Latest post by on 15 Feb 2018 at 6:40pm

TDP Azure Connection

Expand content
My company has an Azure database, and I can connect through SSMS with active directory authentication. I cannot connect through TDP 4.3 because as soon as I enter the database, the authentication type...

My company has an Azure database, and I can connect through SSMS with active directory authentication. I cannot connect through TDP 4.3 because as soon as I enter the database, the authentication type changes to sql server authentication. Are future releases going to have active directory authentication? Is there any way I can connect in TDP 4.3?

Unanswered 182 1 / Create an account to join the discussion.
andy.corson
Follow / 9 Feb 2018 at 4:02pm / Toad Data Point
Latest post by on 13 Feb 2018 at 5:28pm

SQL Formatter

Expand content
I just started using TDP 4.3 and I noticed that the default formatter puts column aliases before the column name in SQL Server. TDP 3.7 put the alias after the column name on the same line. I also see...

I just started using TDP 4.3 and I noticed that the default formatter puts column aliases before the column name in SQL Server. TDP 3.7 put the alias after the column name on the same line. I also see that the custom formatter options are for Oracle, not SQL Server when logged into a SQL Server DB. There is also no vertical scroll bar in the Custom window. How do I get the formatter to format the same as TDP 3.7? How do I view SQL Server formatter options?

Unanswered 391 1 / Create an account to join the discussion.
jmwatson
Follow / 12 Feb 2018 at 2:20pm / Toad Data Point
Latest post by on 13 Feb 2018 at 1:57pm

Toad Data Point on Vertical Monitor

Expand content
I've recently discovered that the code auto-complete feature in Toad Data Point auto-hides (disappears) within a second of popping up when I'm using the program on a monitor in the vertical position...

I've recently discovered that the code auto-complete feature in Toad Data Point auto-hides (disappears) within a second of popping up when I'm using the program on a monitor in the vertical position. Without changing any settings, if I move/drag the program to a horizontal monitor, it works as intended without issue. I prefer to code on a vertical monitor. Is there anything that I can do to prevent Toad Data Point from auto-hiding the auto-complete feature when using a monitor in the vertical configuration?

Unanswered 357 3 / Create an account to join the discussion.