Toad Data Point - Toad World

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:

  • 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

New Approaches to Managing
Your Evolving  Database Environment

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 ...

 

How to Easily Manage Multiple
Database Platforms and Unstructured Data

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...

Community Discussion

tony.howard
Follow / 26 May 2016 at 8:15pm / Toad Data Point

Multiple selection parameters with TDP iSeries connection

Expand content
I am using Toad Data Point 3.4.0.2038. 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 using Toad Data Point 3.4.0.2038. 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?

Unanswered 16 0 / Create an account to join the discussion.
Knutlov
Follow / 25 May 2016 at 8:42am / Toad Data Point
Latest post by on 26 May 2016 at 2:36pm

Missing duplicates in Data Compare

Expand content
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'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?

51 1 / Create an account to join the discussion.
djenkinson
Follow / 12 Sep 2012 at 5:19pm / Toad Data Point
Latest post by on 26 May 2016 at 2:52am

Issue with Table Column Names In Cross-Connection Query Mode

Expand content
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...

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.

Regards

David

9711 5 / Create an account to join the discussion.