UPGRADE to the latest version of Toad Data Point (4.2)
Download the latest TRIAL of Toad Data Point (v4.2)
Download the FREE Toad Data Point Viewer
Toad Intelligence Central on Quest.com
Toad Intelligence Central Community on ToadWorld
Product Information on Quest.com
Toad Data Point Release Notes and Product Guides
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:
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!
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,
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
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.