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

JLHorn
Follow / 25 Jun 2013 at 12:05am / Toad Data Point
Latest post by on 29 Apr 2016 at 7:45pm

Want to save a Fixed Width Text File

Expand content
I have a query that I would like to automatically save to a fixed width text file, although the columns can have different widths, from Toad Data Point 3.2. Here are the different methods I've tried...

I have a query that I would like to automatically save to a fixed width text file, although the columns can have different widths, from Toad Data Point 3.2.   

Here are the different methods I've tried:

- Tools\Export\Export Wizard allows me to build and save an export template but doesn't have the option for custom column widths

- Right clicking on the Result Set of the query I just executed and selecting Export\Export Wizard does give the option to enter custom column widths but it doesn't give me the option to save the export template.

- From the Report designer I can export the document as a .txt file manually.  It's in the proper format because I lpad & rpad everything to the proper widths.  But when I go to automate the .tdr I lose the option of exporting it as a . txt file.

Thanks for your help!

Jason Horn

Database Analyst

Concordia University

Answered 12997 7 / Create an account to join the discussion.
alessandro.folloni
Follow / 7 Dec 2015 at 11:35am / Toad Data Point
Latest post by on 26 Apr 2016 at 8:37am

Oracle connection issue with password containing special charater...

Expand content
Hi All, I'm facing a problem in connecting to oracle 10g with a password containing some special characters (double quote and dollar): " and $ I can connect correctly using sqlplus...

Hi All,

I'm facing a problem in connecting to oracle 10g with a password containing some special characters (double quote and dollar):

"

and

$

I can connect correctly using sqlplus and sql developper, but when I try with my toad data point I get the following error:

System.ArgumentException
Invalid character in non-quoted parameter value
Stack Trace:
at Devart.Common.r.a(Hashtable A_0)
at Devart.Common.r..ctor(String A_0, Hashtable A_1, Boolean A_2)
at Devart.Data.Oracle.ce..ctor(String A_0)
at Devart.Data.Oracle.au.a(String A_0, r A_1)
at Devart.Common.DbConnectionFactory.a(String A_0, r& A_1)
at Devart.Common.DbConnectionBase.set_ConnectionString(String value)
at Quest.Toad.Db.ConnectionProxy.Implementation.ConnectionImplementation..ctor(String fullType, String connectionString)
at Quest.Toad.Db.ConnectionProxy.ProxyConnection.ActualCreateConnection(Object[] parameters)

I tried escaping with backslash, double backslash, surrounding with apexes but nothing works.

Any idea?

Thanks in advance.

731 2 / Create an account to join the discussion.
chanchalsheik
Follow / 15 Jan 2015 at 10:52am / Toad Data Point
Latest post by on 26 Apr 2016 at 8:35am

Error: [Teradata Database] [3704] 'š' ('A0'X) is not...

Expand content
Team, Getting Error: [Teradata Database] [3704] 'š' ('A0'X) is not a valid Teradata SQL token. while executing code; select top 10 * from SVC_BASE.S_EVT_ACT_X where ATTRIB_43...

Team,

Getting Error: [Teradata Database] [3704] 'š' ('A0'X) is not a valid Teradata SQL token. while executing code;

select top 10 * from SVC_BASE.S_EVT_ACT_X where ATTRIB_43 ='87901041270'

 

Any suggestion/advice?


Chanchal Sheik
chanchalsheik@gmailcom

11023 4 / Create an account to join the discussion.