[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
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
Medium Priority
?
695 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
[X]
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
  • 3
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 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 2000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

656 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