Before you install AIA you should know this is not license free, but this can save you a lot of money and helps you to reduce the human factor in your deployments.
This deployment framework is part of a bigger AIA plan and is based on Oracle Best practices, but this can also be used for environments where they don't work with AIA.
To use this deployment framework you should have a running SOA Suite & installed AIA on a machine. For installation instructions see my Whitehorses blog.
And here is the official documentation of this deployment framework.
The first step is to add your WebLogic ( SOA Suite ) Server and Database connections details to the AIAInstallProperties.xml file, this located in your AIA instance folder, in my case (
C:\oracle\AIAPS3\aia_instances\AIAInst1\config ).
Add your Database connections under /properties/participatingapplications/AIAEmployeeSync/db
AIAEmployeeSync is my demo application.
Add your WebLogic connections under /properties/pips/AIAEmployeeSync/server
In my case the password are already encrypted, but you need to encrypt them again. So set the isencrypted element to false and replace the encrypted password with their plain text values.
open a command windows
cd C:\oracle\AIAPS3\util
c:\oracle\AIAPS3\aia_instances\AIAInst1\bin\aiaenv.bat
ant -f createStore.xml generate -DPropertiesFile=%AIA_INSTANCE%\config\AIAInstallProperties.xml
This will encrypt all the password fields.
Now we can take a look at the deployment plan. Here you see for example the scott Datasource which we just configured in the AIAInstallProperties xml file and it has also a reference to the WebLogic server where it needs to deployed to. With ManagedServer you can reboot the WebLogic server and UpdateMetadata does the necessary MDS updates.
You can also make an undeployment plan. This is nice because you can re-test the whole deployment on your test or acceptance server.
I made a handy start script to start this deployment
Also for the undeploy
We are reading to start the deployment.
open a command window and go the location of your ANT xml's
cd C:\projecten\workspace\11g_prod\AIAEmployeeSyncPS3\config
C:\oracle\AIAPS3\aia_instances\AIAInst1\bin\aiaenv.bat
ant -f deployEmployeeSync.xml
And if everything is Ok you should have everything installed & deployed, but you can always check your deployment log for errors.
When you look for your Resource Adapter definitions then you should look for AIA_XXX
The End
Hi Edwin ,
ReplyDeleteCould you please let me know if i can invoke a DBAdapter asynchronously . i am assuming that the DBAdapter always gets invoked synchronously.
A legacy system written in PL/SQL procedures written to process huge chunk of data ( kind of adapter which processes more than 2000 files each invoke updates some tables , which takes around 6 hrs to complete ). and we are trying to invoke those pl/sql procedures to integrate the system with SOA(11G).
We have developed a BPEL communicating to DB through DBadapter ( invokes the required PL/SQL procedures ).
All BPELs used are asynchronous processes . wanted to know how the DB Adapter works . is it a good practice to make the BPEL wait for the pl/sql procedure to return (Though BPEL process is a Asynchronous one) .
Please advice me on this .
Hi
ReplyDeleteYou can do it on many ways, like put the request in aq and a db job read the queu and start the plsql procedure. But there is always something waiting for this plsql procedure.
Bpel is a good way because it has state and the SOA suite automatically put it in the dehrydation database , even with many instances is no problem for bpel. Maybe you only need to tune the repos database.
Thanks