Toad Data Point - Toad World

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

Toad Data Point v4.2 is now available 

Check out what's new!

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

yan2
Follow / 19 Mar 2017 at 3:22am / Toad Data Point Beta Program
Latest post by on 24 Jun 2017 at 1:54am

Azure SQL DB - object MS_Description cannot be displayed

Expand content
There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft...

There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft.com/en-us/library/ms180047.aspx, the green checkmark next to Azure SQL DB is new (since Jan apparently).

e.g. the following statement does not error out anymore - it did last time I tried a few months ago.

EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = 'test description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE',  @level1name = 'mytable' 


Can TDP be updated to act like with SQL Server connections and allow to display the Description, among others,

  • of the columns in the properties tab of a table
  • in the Object Explorer context-menu, Options > Extra Columnazure (in both Tables and Columns panes)
210 3 / Create an account to join the discussion.
PGW
Follow / 19 Jun 2017 at 5:42pm / Toad Data Point
Latest post by on 22 Jun 2017 at 11:44pm

How to Create a Correlated Sub-query in Toad Data Point using Visual...

Expand content
Hello, I am evaluating Toad Data Point as a replacement for OracleEPM/Hyperion/Brio. So far, I like what we see, but want to test in a bit more detail. I am not a developer but an applied data analyst...

Hello,

I am evaluating Toad Data Point as a replacement for OracleEPM/Hyperion/Brio. So far, I like what we see, but want to test in a bit more detail. I am not a developer but an applied data analyst. I generally do not write SQL directly, but rely instead on a visual query builder.

I need help writing a correlated subquery using the visual query designer in Toad Data Point. I can build a subquery but cannot figure out how to join it back to the main query properly. What follows is the SQL we wish to replicate using the Visual Designer in TOAD Data Point:

          SELECT AL1.SGBSTDN_PIDM, AL1.SGBSTDN_TERM_CODE_EFF FROM SATURN.SGBSTDN AL1 WHERE (AL1.SGBSTDN_TERM_CODE_EFF IN

          (SELECT MAX ( AL2.SGBSTDN_TERM_CODE_EFF ) FROM SATURN.SGBSTDN AL2 WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)))

I've exported the above from Oracle EPM/Hyperion/Brio. Of course, I can paste it into the query builder in TOAD Data Point, execute it, and it works fine. However, I would like to be able to build it using the visual designer (the DIAGRAM tab in Query Builder). The particular thing I cannot figure out is how to link the subquery back to the main query, which is represented by this:

          WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)

I understand that Toad Data Point may approach a problem like this differently than did Oracle EPM/Hyperion/Brio, I just can't figure out what that approach may be.

Thanks for any advice you may have, and please forgive my ignorance.

Paul

Unanswered 104 4 / Create an account to join the discussion.
N.B.
Follow / 15 Jun 2017 at 8:53pm / Toad Data Point
Latest post by on 22 Jun 2017 at 11:13am

Toad Data Point on Windows Server (2008 R2, 2012, 2016)

Expand content
This is both a question and a topic for discussion, so... :-) I'm looking to get some feedback on anyone who is running Toad Data Point on Windows Server OS's instead of Windows Desktop OS's...

This is both a question and a topic for discussion, so... :-)

I'm looking to get some feedback on anyone who is running Toad Data Point on Windows Server OS's instead of Windows Desktop OS's - i.e. Windows Server 2008 R2, Windows Server 2012, Windows Server 2016 instead of Windows 7, Windows 8.1, Windows 10.

We've entered in to the lifecycle refresh of our current automation hosts - two Dell OptiPlex desktops with Windows 7 - and we've been asked to consider migrating to virtual machines.  While I'm comfortable with doing that, the problem is that our Virtual Infrastructure doesn't allow Desktop OS's on non-VDI instances - and VDI won't work for us because it's not persistent by design.  So our only choice is our pick of Windows Server versions.

Unlike my typical approach of jumping into the deep end with both feet, I thought I would ask all of you if you've had any experience with this type of setup, virtual or physical, and if you've had any issues.

161 6 / Create an account to join the discussion.