In this post, you will learn a quick way to deploy File based MDS to database.
Assume you are using default SOA_DesignTimeRepository as shown below.
Right click SOA_DesignTimeRepository and select Transfer as shown below.
Select the Resources/Folders that you want to deploy to DB MDS.
Click + for Target Connection to bring up Create SOA-MDS Connection window. Enter Connection Name and select Connection Type, Connection and MDS partition as shown below. Typically, you would select a connection having MDS schema credentials. You can also verify the database connectivity using Test Connection.
Click OK and verify Target Connection is updated as shown below.
Click Transfer and verify that success message is shown up as below.
Click OK. In Resource Palette, verify that resources have been transferred and shown up as below.
This approach enables developer to deploy file based MDS quickly and improve the productivity and definitely one of my favorite features in 12c.
Hi Shive,
Facing the same issue, any fix for below issue
Regards,
Lavanya
Hi Siva,
I am using the DEV_MDS schema only .
Hi Siva,
I have used a Compact domain (Not the default Integrated Weblogic domain) . I am using Oracle DB as my repository schema . I am trying to create a DB based runtime MDS connection in Jdev , but the partition is not displaying as soa-infra. I checked the MDS information from EM console and it is showing a filebased MDS during runtime. From your blog post it looks like you are able to create a DB Based MDS. Can you kindly guide.
What are the connection details you are usingg..are you using _MDS schema only?