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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

688 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