Install and Configure CA Automation Suite for Clouds Powered by Amazon Web Services › Create MDB Tables

Create MDB Tables

The MDB tables are created to store information of different service offerings by Amazon Web Services.

Follow these steps:

1. Download the CA ASC Amazon Web Services folder from the CA Support website.
2. Copy the CA ASC Amazon Web Services folder to %USM_HOME% \filestore\contentpacks\.
3. Navigate to the following directory on the CA Service Catalog server:

   %USM_HOME% \filestore\contentpacks\CA ASC Amazon Web Services\bin\DBScripts

4. Double-click the CreateAWSSchema.cmd file to install the database items.

   The following tables are created:

   • ASC_AWS_ALARMS
   • ASC_AWS_AMI
   • ASC_AWS_AMIs_Sync_Log
   • ASC_AWS_EBS_VOLUMES
   • ASC_AWS_ELASTIC_IPS
   • ASC_AWS_ELBS
   • ASC_AWS_GROUP_VBT
   • ASC_AWS_GROUPS
   • ASC_AWS_PAM_ACCOUNTS
   • ASC_AWS_REGION_TYPES
   • ASC_AWS_REGIONS
   • ASC_AWS_SNAPSHOT_VOLUMES
   • ASC_AWS_SNAPSHOTS
   • ASC_AWS_VBS
   • ASC_AWS_VBT

   The required MDB tables are created.