Build Oracle DB/Tables
Now let’s set up a table that our Recorder is going to record things to. This will create an on-premise back-up if something happens out there in the cloud to our DynamoDB.
The first thing you are going to need to is connect to the CESDEV database. We aren’t making anything for production right now, and CESCPY gets refreshed every week (we definitely don’t want to have to remake the table every week). Fortunately, the CESDEV table fits our needs perfectly.
Open SQL Developer and click the green +.
Then enter the information for the connection to the database.
When you are done, click “Test”. If it works, click “Save”. If it doesn’t work and you’ve double checked everything, you may need to go visit the DBAs.
Now that you have a connection, let’s make us a table!
If you want to understand better what you are doing here, check out https://www.geeksforgeeks.org/sql-create/. The “NOT NULL” part tells it that there has to be something in the database at the spot.
Sweet, your table is ready!
Let’s do one more thing before we move on. We are going to want our server to be able to access our database, so let’s put our username and password in the AWS Parameter Store.
Log into AWS and use the Systems Manager to pull up the Parameter store. It should be in the bottom left-hand side of the screen:
Once you are there, click “Create Parameter” in the top right hand corner.
Make two, with the names:
/(your first name)-(your last name)-favorite-color/dev/DBUSER
/(your first name)-(your last name)-favorite-color/dev/DBPASSWORD
Make it a secure string. For the “Value” of /
When it’s done it should look a bit like this when you look up your parameters:
