Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Running an application automatically

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Running an application automatically
 Login/Join
 
anrix
Member
posted
Hello,
I have this new task, and I do not know how to begin.

They have asked me to create a process to run automatically at a certain time in the day (every day): this process, read some data from an Oracle DB 10g and write the data into a table in another Oracle 10g DB.

The Master is already developed, The process has only read the data and place them in another table in another DB, every day at same time


I ask, I can do with WebFOCUS Developer Studio 7.6.10. ? or what tools would be possible to create the process?

Thanks for your help!

Saludos!

Tony

This message has been edited. Last edited by: Kerry,


WebFocus 7.6.10, windows 7, win server 2003-2008 PDF, TXT, XML, html, xls, doc
 
Posts: 22 | Registered: January 06, 2011Report This Post
Prarie
Virtuoso
posted Hide Post
You will have to create a fex with the fields you want and hold it to a Hold file in the location you want in the format you want.

Then you schedule it in ReportCaster.

Have you had any training?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
anrix
Member
posted Hide Post
hola!

I've had some experience in Developer Studio, creating basic FEX (40) and linking them to HTML.

Report Caster is a product that requires a license?

Thanks!

Tony


WebFocus 7.6.10, windows 7, win server 2003-2008 PDF, TXT, XML, html, xls, doc
 
Posts: 22 | Registered: January 06, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Yes, you need a licence.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
The other ooption is the use an OS scheduler.

The windoes Scheduler, or CRON on Unix.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
More than Dev Studio, what you have explained can be very well done with iWay DM using a simple transform. But agin, that needs a seperate licence.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Else, as said with a fex which has code to reterive data from one table and insert it into another table (SQL pass through is a much opt approach - if you need no change in the data migrating) and schedule that with a ReportCaster Job, on daily frequency.

Depends on your requirment though !


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
anrix
Member
posted Hide Post
[CLOSED]
First I´ll try to use the option that proposes Waz (Windows Scheduler). I think it's interesting.

If it doesn´t working as I need, I will use the Report Caster

Thank you very much everyone for their ideas and responses

Greetings!

Tony


WebFocus 7.6.10, windows 7, win server 2003-2008 PDF, TXT, XML, html, xls, doc
 
Posts: 22 | Registered: January 06, 2011Report This Post
Waz
Expert
posted Hide Post
If you use the windoes scheduler, you will need to call edastart with the the option -x or -f.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Hi Waz,

It's a better idea to use a OS schedule.

I jus have a querstion here ...

Can a OS scheduler directly invoke a FEX and do the Job? Do'nt it need a OS specific script to do that ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Waz
Expert
posted Hide Post
As mentioned in the post above, get the OS Scheduler to call edastart.bat with -x or -f options.

http://techsupport.information...utions/41352515.html


If you run edastart -?, it will show you the options.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Thank you Waz, for the Info.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Saravanan J
Silver Member
posted Hide Post
I have used edastart in a unix shell script and it works perfect. However you need to set the environmental variables before calling edastart command (especially the oracle home path and stuffs).

Here is a command line to call a fex procedure:

/opt/ibi/srv77/wfs/bin/edastart -x "EX commission_statement/main &PARAM1=$BD" > ./WFlogs_$BD.log


Release : 7.7.02
OS : Linux
App Server : Tomcat
all output
 
Posts: 36 | Registered: February 03, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Running an application automatically

Copyright © 1996-2020 Information Builders