Toad Data Point - Toad World

Toad Data Point v4.0 is now available. 
Learn what's new in this release

What's better than data sharing, SQL sharing and workflow sharing?  Getting it for FREE.
Find out how you could get a FREE perpetual TOAD INTELLIGENCE CENTRAL ... $5000 valueOffer valid only until September 30th.

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

bill.staley
Follow / 25 Jul 2016 at 3:45pm / Toad Data Point
Latest post by on 26 Jul 2016 at 3:36pm

Problem when I schedule an automation script

Expand content
When I schedule this automation script, it errors out and I get this message in the log. "Rpt_99.log: Export_1 - Could not find a part of the path 'M:\East\05. Respite Cost Plans Per person'...

When I schedule this automation script, it errors out and I get this message in the log.  "Rpt_99.log: Export_1 - Could not find a part of the path 'M:\East\05. Respite Cost Plans Per person'."

The path and file is not associated with this script anywhere.

Here is a copy of the log file.

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Setting up environment

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Script run by Toad Data Point 4.0.0.613 as DD01150 on DD0119WN21996

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Build started

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Compiling script

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Start CompileWorkflow

-- 7/25/2016 5:00:06 AM: Rpt_99.log: Before Compile

-- 7/25/2016 5:00:10 AM: Rpt_99.log: Return from CompileWorkflow

-- 7/25/2016 5:00:10 AM: Rpt_99.log: Workflow Compiled without Errors

-- 7/25/2016 5:00:10 AM: Rpt_99.log: Build completed

-- 7/25/2016 5:00:10 AM: Rpt_99.log: Create Workflow instance

-- 7/25/2016 5:00:11 AM: Rpt_99.log: Started workflow instance

-- 7/25/2016 5:00:11 AM: Rpt_99.log: Begin execution script activities

-- 7/25/2016 5:00:11 AM: Rpt_99.log: Variable "ROOT_PATH" set to ''

-- 7/25/2016 5:00:11 AM: Rpt_99.log: Running export template C:\TOAD Data\Template\99. Costplan Activity.txp

-- 7/25/2016 5:00:12 AM: Rpt_99.log: Executing export using connection in template is not XQuery Connection

-- 7/25/2016 5:00:14 AM: Rpt_99.log: Export_1 - Could not find a part of the path 'M:\East\05. Respite Cost Plans Per person'.

-- 7/25/2016 5:00:14 AM: Rpt_99.log: This file was not available at runtime. The location and user authentication may be different at runtime.

-- 7/25/2016 5:00:14 AM: Rpt_99.log: Start error email

 

I have other scripts that are failing with the same error message.

Any ideas about what is causing this?

Unanswered 73 2 / Create an account to join the discussion.
Dave - Stt
Follow / 22 Jul 2016 at 9:26pm / Toad Data Point
Latest post by on 25 Jul 2016 at 4:57pm

TDP v4, Navigation Manager

Expand content
Hello, I noticed when you double click a saved connection (oracle) in v4 the dialog box defaults to the connection name not the pasword like in previous versions. I did accidentally rename a couple of...

Hello,

I noticed when you double click a saved connection (oracle) in v4 the dialog box defaults to the connection name not the pasword like in previous versions.  I did accidentally rename a couple of my connections as my password. 

88 4 / Create an account to join the discussion.
bill.staley
Follow / 22 Jul 2016 at 7:31pm / Toad Data Point
Latest post by on 22 Jul 2016 at 11:51pm

Row count in Export - ticket QAT-7302

Expand content
What is the status of the ticket QAT-7302. Provides the number of rows exported, in a variable. This would be a great thing for me to be able to embed in emails.

What is the status of the ticket QAT-7302.  Provides the number of rows exported, in a variable.

This would be a great thing for me to be able to embed in emails.

90 1 / Create an account to join the discussion.