Our team is looking to eventually automate the deployments of the Semantic Model through an end-to-end CI/CD workflow.

Current State:

We use Oracle Visual Builder Studio to manage a git repo that contains the JSON files that make up the Semantic Model. We use the OAC Semantic Modeler tool to pull from our git repo, make changes, and then push and merge. We only have our non-production instances of OAC connected to the git repository for security concerns (we don't want to establish an SSH or HTTPS direct connection between Visual Builder and our production OAC). Instead, we manually download the latest version of our Semantic Model to a .zip file and then manually upload the file to a separate Semantic Model in our Production OAC. We then deploy the Semantic Model from within production OAC.

Client Tools are Insufficient:

We were recommended to look into installing the OAC client tools, since they contain utilities to convert the Semantic Model JSON to RPD and to then deploy the RPD to OAC, yet we don't want to persist / manage a custom VM in OCI Compute just to host these client tools on the cloud. We were also looking into whether we can install the client tools into a VM in Visual Builder Studio, but we're not sure if we can install the tools from the command line only.

Proposal:

Include the JSON to RPD and RPD deployment tools in the OCI SDK to help simplify the creation of a CI/CD pipeline for Semantic Models. An SDK will allow for pipelines to be built more quickly and more reliably, a deeper integration of Semantic Model deployments in enterprise approval processes, and the ability to extend Oracle's model consistency checking with tests of our own.