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
678 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 73

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 73

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 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query 5 70
PAYER_ID has both atributes 4 32
Oracle SQL 6 48
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword 2 0
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now