Creating Docker container to connect to Oracle Database
While working with a customer, a question was brought up how to manage the Oracle Database and MS SQL with GitHub Actions. I recently had a chance to automate the SQL connection, creation of database tables, and insertion for MariaDB on Amazon Web Service (AWS) using GitHub Actions, so I was pretty much confident that Oracle Database and MS SQL can work in a similar way. After all, working with any type service typically can be simplified into only two steps.
- Getting connected by logging into the service
- Perform operation
First part “Getting connected by logging into the service” is usually the hardest because it requires the client side to have an appropriate tool, whether it is a Command Line Interface (CLI) or a Software Development Kit (SDK) of some sort, to call that service. And most service requires a secure connection, so you also need to find out how to call that service with sometime of username & password pair or some type service connection.
Naturally, first question for me was what will be the tool to connect to Oracle Database. When I was testing with MariaDB, that part was pretty easy because GitHub Actions’s default hosted runner came up with MySQL client, which can be also used to connect to MariaDB. But connecting to Oracle Database has to follow one of…
