This content has been marked as final. Show 2 replies
You can not imbed SAS Scripts and have the Oracle PL/SQL Engine execute the scripts.
As you noted, there are ways to have Oracle integrate with external programs, such as through Oracle Scheduler.
Oracle Enterprise Manager also allows the invocation of scripts on a machine.
As of January 2012, Oracle offers the ability to run Oracle R Scripts imbedded in PL/SQL as part of the Oracle Advanced Analytics Option, which also includes Data Mining.
So assuming you could accomplish what you need using Oracle R and Oracle Data Mining, you could have a process that is fully integrated within the DB.
Thanks for help.
I checked other possibilities to interact between these technologies ans I see two:
- webservices (call from PL/SQL SAS program accesible as webservice);
- Java Messaging System (but I don't have clear vision about architecture of this solution).
Does anybody know any other possibilities ?
Thanks in advance,