1. Home
  2. Knowledge Base
  3. GoldenGate
  4. Oracle GoldenGate Cloud Service for MS SQL Server
  1. Home
  2. Knowledge Base
  3. Oracle Cloud
  4. Oracle GoldenGate Cloud Service for MS SQL Server

Oracle GoldenGate Cloud Service for MS SQL Server

In March earlier this year Oracle announced Oracle GoldenGate Cloud Service support for more than 40 source and target technologies including Snowflake, MongoDB, Microsoft SQL Server, Azure SQL Database, Oracle Autonomous JSON Database, Oracle NoSQL, Azure Cosmos DB for MongoDB among others.

https://blogs.oracle.com/dataintegration/post/oci-goldengate-adds-support-for-snowflake-mongodb-microsoft-sql-server-azure-sql-database-oracle-autonomous-json-database-oracle-nosql-azure-cosmos-db-for-mongodb-and-more

In this example, we will see how to create a deployment for Microsoft SQL Server using the newly released Oracle GoldenGate Cloud Service version 21.9.

A deployment is where we create and manage Oracle Cloud Infrastructure GoldenGate resources like Extracts and Replicats via a deployment console – as well as through the command line Admin Client.

In the Console navigation menu, click Oracle Database, and then select GoldenGate. On the Deployments page, click Create deployment.

From the Select a technology drop down list we pick the option Microsoft SQL Server.

Provide the GoldenGate instance name along with the administrator username and password – note we will use this account to login both via the deployment console as well as the command line.

Click Create

Wait for the status of the deployment to change from Creating to Active

The following screen shots shows how the command line Admin Client is launched and how to connect to the GoldenGate Cloud Service deployment using the command line Admin Client.

From the Deployment Details page in the OCI console, we can obtain the console URL and then connect to the deployment by providing the GoldenGate administrator account and password.

Create the SQL Server login, database, user and enable CDC in the database.

From the GoldenGate menu in OCI console click on Connections.

Click on Create connection.

Provide a name for the connection and then from the Select a connection type drop down list we pick the option Microsoft SQL Server.

Here we provide details of the SQL Server database – either provide the FQDN or IP address of the SQL Server instance host along with the database name, SQL Server port number as well as the user credentials to connect to the database name provided.

Click on Create and wait till the status of the connection changes from Creating to Active.

After the connection is created and is active, we assign a deployment to the connection. Since the connection is a Microsoft SQL Server connection, the deployment also needs to be a valid Microsoft SQL Server deployment.

Click on the Assign Deployment button.

After the connection has been created and the active connection is assigned to a deployment, if we connect to the deployment console, we can see the connection has created a GoldenGate credential as shown below.

Update the GGSCHEMA parameter in the GLOBALS file.

Click on the icon to connect to the SQL Server database and test that the connection is working fine.

In the next post, we will see how to ADD TRANDATA, Create the Extract as well as the Distribution Path. Watch this space!

Updated on December 13, 2023

Was this article helpful?

Related Articles

Leave a Comment