{"id":4416,"date":"2015-03-19T08:55:00","date_gmt":"2015-03-19T07:55:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/"},"modified":"2015-03-19T08:55:00","modified_gmt":"2015-03-19T07:55:00","slug":"sql-server-change-data-capture-for-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/","title":{"rendered":"SQL Server: Change Data Capture for Oracle"},"content":{"rendered":"<p>This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables.<br \/>\nIn other words, Change data capture records Insert, Update and Delete activities that is applied to Oracle tables.<br \/>\nLet&#8217;s see how it works.<\/p>\n<h3>Prerequisites<\/h3>\n<p>The database where you want to capture changes must be in ARCHIVELOG and OPEN.<br \/>\nThe user which will be used to connect to the Oracle database, must have DBA privileges.<\/p>\n<h3>Change Data Capture services installation<\/h3>\n<p>Installation will be done via msi packages. Those packages are not installed automatically with SQL Server 2012 or 2014. You will find them in your installation media under ToolsAttunityCDCOraclex641033.<br \/>\nThere are two msi packages, one for the CDC Service Configuration named <strong>AttunityOracleCdcService.msi<\/strong> and another for CDC Designer named <strong>AttunityOracleCdcDesigner.msi.<\/strong><\/p>\n<p>Double click on <strong>AttunityOracleCdcService.msi<\/strong> and install the package, same for <strong>AttunityOracleCdcDesigner.msi.<\/strong><\/p>\n<p><strong><em><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice.jpg\" \/><\/a><\/em><\/strong><\/p>\n<p><strong><em><a class=\"easyblog-thumb-preview\" title=\"OracleCDCDesigner.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCDesigner.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCDesigner.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCDesigner.jpg\" alt=\"b2ap3_thumbnail_OracleCDCDesigner.jpg\" \/><\/a><\/em><\/strong><\/p>\n<p>When both installations are done, go to the Application Panel and launch \u201cOracle CDC Service Configuration\u201d.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice2.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice2.jpg\" \/><\/a><\/p>\n<p>We will now have to prepare our SQL Server instance to use it. Each Oracle CDC Service instance lies a single SQL Server instance which will be used to manage it.<br \/>\nTo create this instance click on &#8220;Prepare SQL Server&#8221; or right click on Local CDC Service and select \u201cPrepare SQL Server\u201d:<\/p>\n<p><span style=\"font-size: 10pt; line-height: 107%; font-family: 'Segoe UI',sans-serif; color: #2a2a2a;\"><a class=\"easyblog-thumb-preview\" title=\"CDCSQLServerPrepare.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/CDCSQLServerPrepare.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_CDCSQLServerPrepare.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_CDCSQLServerPrepare.jpg\" alt=\"b2ap3_thumbnail_CDCSQLServerPrepare.jpg\" \/><\/a><\/span><\/p>\n<p>Once it is done select the SQL Server instance where you want to install the MSXDBCDC database and click on the Run button:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CDCSQLServerPrepare2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/CDCSQLServerPrepare2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_CDCSQLServerPrepare2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_CDCSQLServerPrepare2.jpg\" alt=\"b2ap3_thumbnail_CDCSQLServerPrepare2.jpg\" \/><\/a><\/p>\n<p>The database is created:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CDCSQLServerPrepare3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/CDCSQLServerPrepare3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_CDCSQLServerPrepare3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_CDCSQLServerPrepare3.jpg\" alt=\"b2ap3_thumbnail_CDCSQLServerPrepare3.jpg\" \/><\/a><\/p>\n<p>Let&#8217;s check from SQL Server Management Studio the newly created database:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CDCSQLServerPrepare4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/CDCSQLServerPrepare4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_CDCSQLServerPrepare4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_CDCSQLServerPrepare4.jpg\" alt=\"b2ap3_thumbnail_CDCSQLServerPrepare4.jpg\" \/><\/a><\/p>\n<p>At this point we can create a new CDC service:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice3.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice3.jpg\" \/><\/a><\/p>\n<p>To create the windows service we have to provide the following information:<\/p>\n<ul>\n<li>The Service Name<\/li>\n<li>Use a local system account for the service account<\/li>\n<\/ul>\n<p>In addition, we must provide the following information for the associated SQL Server instance:<\/p>\n<ul>\n<li>Server name<\/li>\n<li>Authentication and login<\/li>\n<\/ul>\n<p>The next step consists in creating a master password for CDC service which will be used to create symmetric key.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice4.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice4.jpg\" \/><\/a><\/p>\n<p>After that we will create an instance from the CDC Designer.<br \/>\nWhen I open it, I have to enter the SQL server instance, I have created before, which is associated with the CDC service. Credentials are required to connect to the concerned SQL Server Instance.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice6.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice6.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice6.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice6.jpg\" \/><\/a><\/p>\n<p>After connecting to the SQL Server I can see all related Oracle CDC Services. Next, after selecting the OracleCDCService1, I will create a new instance for this service:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCInstance1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCInstance1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCInstance1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCInstance1.jpg\" alt=\"b2ap3_thumbnail_OracleCDCInstance1.jpg\" \/><\/a><\/p>\n<p>Provide a name to the future CDC Instance and then create the change associated database:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCInstance2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCInstance2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCInstance2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCInstance2.jpg\" alt=\"b2ap3_thumbnail_OracleCDCInstance2.jpg\" \/><\/a><\/p>\n<p>After clicking on \u201cCreate Database\u201d button the wizard will assist us to create the new Oracle CDC instance and the change database.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice7.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice7.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice7.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice7.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice7.jpg\" \/><\/a><\/p>\n<p>Click Next.<br \/>\nWe have now to fill out the form with following information:<\/p>\n<ul>\n<li>the Oracle connection string to our listener<\/li>\n<li>user name<\/li>\n<li>password<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice8.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice8.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice8.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice8.jpg\" \/><\/a><\/p>\n<p>Check if the connection to the source is successful:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice9.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice9.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice9.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice9.jpg\" \/><\/a><\/p>\n<p>Click Next and then click on the Add button to select tables and columns for capturing changes.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice10.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice10.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice10.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice10.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice10.jpg\" \/><\/a><\/p>\n<p>Select the schema and click on the Search button.<br \/>\nSelect the SCOTT.EMP table and click on the Add button.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice11.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice11.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice11.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice11.jpg\" \/><\/a><\/p>\n<p>A message warns up that the SCOTT_EMP table has been added to the list:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice12.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice12.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice12.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice12.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice12.jpg\" \/><\/a><\/p>\n<p>Now, you can see the table in the list:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice13.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice13.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice13.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice13.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice13.jpg\" \/><\/a><\/p>\n<p>The Capture instance column, here SCOTT_EMP, will be used to name the capture instance specific to each table object in my SQL Server database.<\/p>\n<p>At this point, no CDC gating role is specified so it means that no gating role will be used to limit access to the change data.<\/p>\n<p>By default all the columns of the SCOTT.EMP table are selected for CDC. If I want to select just some columns I can click on the Edit button and choose the columns I want in CDC.<br \/>\nClick on OK when your selection is finished and after click on Next:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice17.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice17.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice17.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice17.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice17.jpg\" \/><\/a><\/p>\n<p>To be able to capture Oracle changes, supplemental logging have to be set up for the Oracle databases tables. For this purpose, a script have been generated automatically and have to be run immediately or later but you have to be aware that changes will not be captured until the script is executed.<br \/>\nClick on the \u201cRun Script\u201d button:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice14.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice14.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice14.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice14.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice14.jpg\" \/><\/a><\/p>\n<p>In order to run the script some credential must be provided and after click on the Run button:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice15.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice15.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice15.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice15.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice15.jpg\" \/><\/a><\/p>\n<p>The script has been executed with success:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice16.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice16.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice16.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice16.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice16.jpg\" \/><\/a><\/p>\n<p>Click on Next and in the last screen click on the \u201cRun\u201d button to finalize the CDC process:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice18.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice18.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice18.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice18.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice18.jpg\" \/><\/a><\/p>\n<p>It looks like I have some errors&#8230;<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice19.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice19.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice19.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice19.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice19.jpg\" \/><\/a><\/p>\n<p>Let\u2019s click on Details:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice20.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice20.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice20.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice20.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice20.jpg\" \/><\/a><\/p>\n<p>Apparently I forgot to set up my Oracle database for supplemental logging, let\u2019s do it:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice21.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice21.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice21.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice21.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice21.jpg\" \/><\/a><\/p>\n<p>Now, we can click on the Next button:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice22.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice22.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice22.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice22.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice22.jpg\" \/><\/a><\/p>\n<p>We have successfully created an Oracle CDC instance. Let\u2019s check on my SQL Server:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice23.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice23.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice23.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice23.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice23.jpg\" \/><\/a><\/p>\n<p>The mirror table will be always empty conceptually. The generated deployment script denies all DML permissions on the mirror table.<\/p>\n<p>I have a new database named OracleCDCInstance1 with, for the moment, an empty table named SCOTT.EMP, which is the table I selected earlier from the wizard.<\/p>\n<p>Back to my CDC Designer, I see that I have now an OracleCDCInstance1 which is for the moment not started:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice24.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice24.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice24.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice24.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice24.jpg\" \/><\/a><\/p>\n<p>Now let&#8217;s start the instance:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice25.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice25.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice25.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice25.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice25.jpg\" \/><\/a><\/p>\n<p>The Detailed status has changed from Initial to IDLE:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice26.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice26.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice26.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice26.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice26.jpg\" \/><\/a><\/p>\n<p>It may take a few minutes (one or two) to start change capture process. You may notice the detailed status that will change from IDLE to PROCESSING. Likewise, Processing and Counters areas will also change as oracle logs are ridden.<br \/>\nHere I performed an update of the salary column in my table SCOTT.EMP from my Oracle database:<\/p>\n<p><span style=\"color: #333333; background: none repeat scroll 0% 0% white;\"><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice28.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice28.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice28.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice28.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice28.jpg\" \/><\/a><\/span><\/p>\n<p>We can see that the twelves operations are reflected in the counters area as twelves reads:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice27.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice27.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice27.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice27.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice27.jpg\" \/><\/a><\/p>\n<p>If the Detailed Status changes to LOGGER instead of PROCESSING, it means that even you have a temporary delay mining Oracle logs and in this case PROCESSING will come back quickly even you have a problem of mining Oracle logs and in this case check the <strong>dbo.xdbcdc_trace<\/strong> in the <strong>MSXDBCDC<\/strong> database to check errors.<\/p>\n<p>We are also able to check information from log traces by clicking on the \u201cCollect diagnostics\u201d link which will generate diagnostics data from both Oracle environment and dbo.xdbcdc_trace table into a trace file:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"OracleCDCSercice29.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/CDC Oracle\/OracleCDCSercice29.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_OracleCDCSercice29.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice29.jpg\" alt=\"b2ap3_thumbnail_OracleCDCSercice29.jpg\" \/><\/a><\/p>\n<p>This feature gives the opportunity to use Change Data Capture in a SQL Server database using an Oracle database as a source. A major advantage of using CDC for Oracle is certainly the reduction of data level latency and at the same time, Oracle ETL knowledge becomes useless. It is also a good way to source SQL Server database with Oracle Data.<br \/>\nHope this article will help you, envoy \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables. In other words, Change data capture records Insert, Update and Delete activities that is applied to Oracle tables. Let&#8217;s [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":4417,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[],"type_dbi":[],"class_list":["post-4416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: Change Data Capture for Oracle - dbi Blog<\/title>\n<meta name=\"description\" content=\"SQL Server 2012: Change Data Capture for Oracle Database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Change Data Capture for Oracle\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2012: Change Data Capture for Oracle Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-19T07:55:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"381\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server: Change Data Capture for Oracle\",\"datePublished\":\"2015-03-19T07:55:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/\"},\"wordCount\":1118,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_OracleCDCSercice.jpg\",\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/\",\"name\":\"SQL Server: Change Data Capture for Oracle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_OracleCDCSercice.jpg\",\"datePublished\":\"2015-03-19T07:55:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"SQL Server 2012: Change Data Capture for Oracle Database\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_OracleCDCSercice.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/b2ap3_thumbnail_OracleCDCSercice.jpg\",\"width\":500,\"height\":381},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-change-data-capture-for-oracle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Change Data Capture for Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \\\/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-savorgnano\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Change Data Capture for Oracle - dbi Blog","description":"SQL Server 2012: Change Data Capture for Oracle Database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Change Data Capture for Oracle","og_description":"SQL Server 2012: Change Data Capture for Oracle Database","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/","og_site_name":"dbi Blog","article_published_time":"2015-03-19T07:55:00+00:00","og_image":[{"width":500,"height":381,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server: Change Data Capture for Oracle","datePublished":"2015-03-19T07:55:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/"},"wordCount":1118,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg","articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/","name":"SQL Server: Change Data Capture for Oracle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg","datePublished":"2015-03-19T07:55:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"SQL Server 2012: Change Data Capture for Oracle Database","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_OracleCDCSercice.jpg","width":500,"height":381},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-change-data-capture-for-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Change Data Capture for Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4416"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4416\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4417"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4416"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}