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
677 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

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.

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

743 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

15 Experts available now in Live!

Get 1:1 Help Now