UPGRADE (v3.8)TRIAL (v3.8)
Toad Intelligence Central 2.7
FREE Toad Data Point Viewer
These people make Toad Data Point great and have the most points for this month!
Toad™ Data Point is a multi-platform database query tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare it all, and 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:
Use these links below to learn more about the most popular Toad Data Point topics!
We’re seeing many organizations move toward agile methodologies. But with the transition from manual change-and-release management to an automated approach of continuous integration comes new challenges ...
Are you struggling to manage an increasingly complex database environment? If so, you’re not alone. Research shows that data growth is doubling every 18 months. And it’s not...
I am using Toad Data Point 22.214.171.1248. Using an iSeries database connection I have created an SQL to select data from a table. I want to use multiple parameters for the data selection. My problem is that I am able to use 1 parameter fine but if I try to use more than 1, the select does not return data. I can use 1 parameter and hard code the second select and it will work. Example: Select * from Filename where field1 = : parm1 and field2 = :parm2 does not work. When I run the SQL it prompts me for the two values but does not return data. If I use: Select * from Filename where field1 = :parm1 and field2 = ‘Somevalue’, I get prompted for the first parameter and it returns the correct information using both comparisons. I have no issues using multiple parameters with an Oracle connection. Is there something special about using the iSeries?
I'm working on merging two oracle databases and are using Toad Data Point to analyse the content in the tabels. In som cases, when the colomn is a varchar colomn, data point can't find the duplicates. I insert two files with snaps from the same table, to show this. As you can see, klassekode A og B i found, bud klassekode 2 and 3 is not found.
Is there a way to get around this problem?
Hi,I have data which is held in multiple Excel Spreadsheets and imported SharePoint Lists (Sets for each Department Programme), that I want to collect and report on.I have been able to create SQL scripts using the Query Builder on separate Lists and Spreadsheets to create specific reports.However when I try to create a Heterogeneous connection query using the Cross-Connection Query Mode I get an error, which relates to the columns names having spaces in them (e.g. 'Approved Budget'). The Query Builder has no issues with this, but not so when using the Cross-Connection Query Mode.Is this a bug?I am not able to change the table column names and remove the spaces from the SharePoint Lists and Excel Spreadsheets. Is there another way I can make the Cross-Connection Query Mode work?Any help welcome.Thank you in advance.RegardsDavid