Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

quest 1: new to Toad (TDA)  - Is Toad a Web based application or an .exe that is installed on the user's desktop

Posted on 2011-03-15
5
687 Views
Last Modified: 2012-05-11
Hi EE,

At work, we are currently using Oracle Discoverer.
My question is, if Toad is web based or .exe. based. If Toad is  .exe based can it be executed in a .bat file and
fed the query name and ask it to export the results to excel file as i can do with Oracle discoverer as described below.

tx. sandra

Oracle Discoverer comes in 2 flavors:  web based   and desktop based (.exe).

The adv. of .exe is i can call the query using a .bat file like this:
Please note that whenever you see XXX_, that is a variable that i replace in vba with a meaningful value.

C:\oracle\BIToolsHome_1\bin\dis51usr.exe /connect XXX_SignOn/XXX_Password@odsp8 /opendb "SREG.Advisor_CAD_M3enrolled_M4unenrolled_forPostingOnBullentinBoard" /sheet ALL /parameter Parm_AcademicPeriod   xxx_parm1 /export XLS xxx_ExcelFile  /batch

0
Comment
Question by:mytfein
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35138140
toad is a windows executable (.exe)

it does have scripting capabilities that can be invoked via batch files
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 500 total points
ID: 35138153
the above is for Toad for Oracle, I'm not as familiar with the "analyst" version though

it is still a windows executable, but I'm not sure about the extent of its scripting
0
 

Author Comment

by:mytfein
ID: 35138178
hi sdstuber,

tx for writing... that's great....

if work authorized toad/tda to buy, do you think that training vids come with it? are there real classes?
a few months ago i downloaded a trialware, most of the good features were greyed out....

pls advise, tx, sandra
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35138342
no, there are no training videos that come with the product itself

but Toad has pretty good documentation
even better are the online resources like the toad wiki and yahoo groups

I have confirmed you can create task scripts then execute them from the command line
it'll look something like this..,

"C:\Program Files\Quest Software\Toad for Data Analysts 2.7\Toad.exe" -batch=true "d:\temp\tda_Script_1.tas"
0
 

Author Comment

by:mytfein
ID: 35138756
fabulous sdstuber...

that was very nice of you...

tx again, s....  (can you pls check another post that put on EE today, hopefully, it's easy to answer)

tx, s
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question