Switching Visual Builder to Use The Oracle ATP Database by Shay Shmeltzer


Oracle Visual Builder comes with a built in database that is used to store data for your business obejcts (and your apps metada too). That DB, however, is limited to 5GB in size and also doesn’t enable you to access the data in the objects using regular SQL. Luckily, you can point Visual Builder to use another Oracle cloud database including the new Oracle Autonomous Transaction Processing (ATP) database – which will give you more space and direct SQL access to the objects VB creates. You can even use a Free Forever Oracle ATP which will get you 20GB of storage for free. In the demo below we show you the steps to take to do this switch.

The switch over is quite simple and is done with a simple two step wizard in your VB instance settings. You’ll need to provide the connection information to your DB – for an ATP DB this would include the wallet.zip file with the connection info. VB will then do the work for you switching to use the new instance. More info on the process is in our Visual Builder Administration Guide.

One additional step you will need to do in the wizard is to backup (export) any apps you want to keep around. Read the complete article here.

Developer Partner Community

For regular information become a member in the Developer Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook image Meetups

Technorati Tags: PaaS,Cloud,Middleware Update,WebLogic, WebLogic


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.