{"id":91345,"date":"2021-06-15T20:51:51","date_gmt":"2021-06-15T20:51:51","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=91345"},"modified":"2021-10-13T12:51:31","modified_gmt":"2021-10-13T12:51:31","slug":"microsoft-sql-server-to-oracle-database-connectivity-from-ssis-using-attunity-connector","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/microsoft-sql-server-to-oracle-database-connectivity-from-ssis-using-attunity-connector\/","title":{"rendered":"Microsoft SQL Server to Oracle Database Connectivity from SSIS using Attunity Connector"},"content":{"rendered":"<p>Almost every environment now a days need to source data from different source system. Here is how you can establish connection using Attunity Connector from\u00a0Microsoft SQL Server to Oracle Database\u00a0 from SSIS.<\/p>\n<p>This method is extremely fast if you want to land millions and millions of records on the fly from Oracle to SQL Server.<\/p>\n<p>Here are the steps.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><em><u>Step 1<\/u><\/em><\/strong>\u00a0: Download Microsoft Connectors v2.0 for Oracle using the link below.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=55179\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=55179<\/a><\/p>\n<ul>\n<li>Download AttunitySSISOraAdaptersSetup.msi (32 Bit)<\/li>\n<li>Download AttunitySSISOraAdaptersSetupX64.msi(64 Bit)<\/li>\n<\/ul>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQGUbjmQNlORQA\/article-inline_image-shrink_1000_1488\/0\/1623708102480?e=1629331200&amp;v=beta&amp;t=JHmnOXnb8embxfTIyHtM_eji3n1s55QvysYvtvIxr4I\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 2<\/u><\/em><\/strong>\u00a0: Run Setup for both 32 Bit &amp; 64 Bit Attunity Connector on the SQL Server. You can verify this install in the control panel in Program and Features. (*Always run Setup as an Administrator)<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFQKLfl-hEb3Q\/article-inline_image-shrink_1500_2232\/0\/1623708160453?e=1629331200&amp;v=beta&amp;t=26E14TE2sn3Ne84344ddCrJI0cWqGbCiI4Nw6BW3hqE\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 3<\/u><\/em><\/strong>\u00a0: Once Installation is done for both 32 Bit &amp; 64 Bit Attunity Connector on the SQL Server you will be able to see a new component in SSIS Data Flow called \u201c<strong>Oracle Source<\/strong>\u201d &amp; \u201c<strong>Oracle Destination<\/strong>\u201d.<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQHIvcfsTbY1vA\/article-inline_image-shrink_1000_1488\/0\/1623708442642?e=1629331200&amp;v=beta&amp;t=XAv6ghh5BE8BBmmvtZZbzI3pjYcCTVge6552I5G7MTY\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 4<\/u><\/em><\/strong>\u00a0: Download Oracle 12c \u2014\u00a0<strong>64-bit Oracle Data Access Components (ODAC) Downloads<\/strong>\u00a0using the link below.\u00a0<a href=\"http:\/\/www.oracle.com\/us\/products\/tools\/index-090165.html\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/www.oracle.com\/us\/products\/tools\/index-090165.html<\/a><\/p>\n<ul>\n<li>64-bit ODAC 12.2c Release 1 (12.2.0.1.0) for Windows x64 [Released June 1, 2017] (<strong>ODAC122010_x64.zip \u2014 415 MB (435,541,788 bytes)<\/strong>)<\/li>\n<\/ul>\n<p><strong><em><u>Step 5<\/u><\/em><\/strong>\u00a0: Download Oracle 12c \u2014\u00a0<strong>32-bit<\/strong>\u00a0<strong>Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)<\/strong>\u00a0using the link below.\u00a0<a href=\"http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/database12c-win64-download-2297732.html\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/database12c-win64-download-2297732.html<\/a><\/p>\n<p>Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit) (<strong>winnt_12102_client32.zip<\/strong>\u00a0(32-bit) (902,922,170 bytes) )<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQE3tm0WBe9B2A\/article-inline_image-shrink_1000_1488\/0\/1623708498637?e=1629331200&amp;v=beta&amp;t=v7OrIil9SjFjtXkx-6YfIJJasA_gul3ItpJWN6NTNPA\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 6<\/u><\/em><\/strong>\u00a0: First Run Setup for\u00a0<strong>64 Bit Oracle<\/strong>. Below folders will be created in\u00a0<strong>C Drive<\/strong>. (Recommended to create in C Drive) (<strong>*Always run Setup as an Administrator<\/strong>)<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQE0LknqCLTWhg\/article-inline_image-shrink_1000_1488\/0\/1623709540818?e=1629331200&amp;v=beta&amp;t=f_s5T-GGa6wxq1770-fYv8WzG4ElYdNkaQJCX5TrpYg\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFXtLV8lp4xhA\/article-inline_image-shrink_1000_1488\/0\/1623709559243?e=1629331200&amp;v=beta&amp;t=N_Rx6kiSRepjtrGQXhgDXmaJa6y0D17U5PVEVXhxyBU\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQEsSCtLSx3kSg\/article-inline_image-shrink_1000_1488\/0\/1623709568645?e=1629331200&amp;v=beta&amp;t=CdwvdOnXElv03U47wDW8PgVLeljveF7lZib4EhyEtZo\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQEPuShdj-2Csg\/article-inline_image-shrink_1000_1488\/0\/1623709577186?e=1629331200&amp;v=beta&amp;t=CgE0l5NqoI8EFrkKRPNbH3TKKtpgf2oLvYbCxKpkBbU\" alt=\"No alt text provided for this image\" \/><\/div>\n<p>Incase if you see this error below during installation, ignore the error and continue with the installation.<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQHG2dsuBZVygA\/article-inline_image-shrink_1000_1488\/0\/1623709601113?e=1629331200&amp;v=beta&amp;t=0LJ_w8UTM-xe7kiXURm2bcFN6gQq6vyQkJKHMGaW2RQ\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 7<\/u><\/em><\/strong>\u00a0: Modify this\u00a0<strong>\u201ctnsnames.ORA\u201d<\/strong>\u00a0file with appropriate Oracle TNSServicename.<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFP_LOIbTbavw\/article-inline_image-shrink_1000_1488\/0\/1623709628002?e=1629331200&amp;v=beta&amp;t=2vzEH9oaevZ76iAfxw1biKuZTF4urTlrULGXcq0_e2I\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQGTutBuHAccmA\/article-inline_image-shrink_1000_1488\/0\/1623709683721?e=1629331200&amp;v=beta&amp;t=TMcOJZMOQRlDZyNrotb6z5v7S1M9BIKqX49fablcQdo\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 8<\/u><\/em><\/strong>\u00a0: Edit the \u201c<strong>System Environment Variables<\/strong>\u201d. Go to the control Pane and top search box search for environment click on Edit the System Environment Variables, click on Environment Variables go to\u00a0<strong>path<\/strong>\u00a0in System Variables. Make sure below Environment Variables are available if not copy in the Path folder.<\/p>\n<ul>\n<li>C:\\app\\client\\product\\12.1.0\\client_1\\bin;<\/li>\n<\/ul>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQF4eI1hrOHOOA\/article-inline_image-shrink_1000_1488\/0\/1623709732895?e=1629331200&amp;v=beta&amp;t=VHbaenC_pAVO0RnY4fFHVOvvJkKPstvhHgYWl-2hZP0\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQG_GKkaf3XdIw\/article-inline_image-shrink_1000_1488\/0\/1623709743794?e=1629331200&amp;v=beta&amp;t=Tel8Nz6UuAOuvbAn2mXlWvuRlBX38pu64U1vo2Rh2oQ\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 9<\/u><\/em><\/strong>\u00a0:\u00a0<strong>Test<\/strong>\u00a0the\u00a0<strong>Connectivity<\/strong>\u00a0to Oracle after 64 bit Install by running\u00a0<strong>SQLPLUS on CMD<\/strong>.<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFmmCHk_63Axg\/article-inline_image-shrink_1000_1488\/0\/1623709867059?e=1629331200&amp;v=beta&amp;t=LRIYnUtuDs9U_X2yX2moAIDut8qvp9l0dgwHJ5gF62Y\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong>Command<\/strong>: \u2014<\/p>\n<p>sqlplus<\/p>\n<p>User_Name\/Password@(Oracle Server Name)<\/p>\n<p><strong><em><u>Step 10<\/u><\/em><\/strong>\u00a0: If you start running setup for\u00a0<strong>32 Bit Oracle Client without below steps, setup will kick you out.\u00a0<\/strong>Follow below steps and restart the installation setup.<\/p>\n<ol>\n<li>Open Registry (Regedit in CMD)<\/li>\n<li>Go to HKEY_LOCAL_MACHINE\\SOFTWARE\\WOW6432Node<\/li>\n<li>Create a new key with name of \u201cOracle\u201d<\/li>\n<li>Go to Oracle and then create a new String Value with name \u201cinst_loc\u201d<\/li>\n<li>Give the value as \u201cC:\\Program Files\\Oracle\\Inventory\u201d<\/li>\n<\/ol>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQGITmiVvMJhtg\/article-inline_image-shrink_1000_1488\/0\/1623709890890?e=1629331200&amp;v=beta&amp;t=QpKeKuNUf9S1-AwXtnxaq0zP2O-rz0BXllCXrepVLTI\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 11<\/u><\/em><\/strong>\u00a0: Run Setup for\u00a0<strong>32 Bit Oracle Client<\/strong>. Make sure to run\u00a0<strong>\u201cAdministrator\u201d.\u00a0<\/strong>(*Always run Setup as an Administrator)<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQHX2ZvCb_HHqA\/article-inline_image-shrink_1000_1488\/0\/1623709914618?e=1629331200&amp;v=beta&amp;t=aa0OA8VmhdgOHIw0YdXJKqvTllz6P-hbbk08auTHjxQ\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQHxr7kWr7YJiA\/article-inline_image-shrink_1000_1488\/0\/1623709928546?e=1629331200&amp;v=beta&amp;t=e2eLUhwfR9M1Vt-M0Jya85NXl_juTfRQUn8SrL7SxfE\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFEef7XRBaI8g\/article-inline_image-shrink_1000_1488\/0\/1623709941929?e=1629331200&amp;v=beta&amp;t=ehBeAzshbNRXr6pDoddz13QLsSbK6zPvuvW1whEj2Q4\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQE7FpMIESqvmg\/article-inline_image-shrink_1000_1488\/0\/1623709954673?e=1629331200&amp;v=beta&amp;t=UekUo4DUershmJIxerK9P6tVp_lp4BXtccFN3cA7f3I\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 12<\/u><\/em><\/strong>\u00a0: Copy \u201ctnsnames.ORA\u201d &amp; \u201csqlnet.ORA\u201d file from 64 bit folder \u201cC:\\app\\client\\product\\12.1.0\\client_1\\Network\\Admin\u201d if you don\u2019t see after 32 bit Oracle Client Install.<\/p>\n<p><strong>From:<\/strong><\/p>\n<p><strong>C:\\app\\client\\thakkn91\\product\\12.2.0\\client_1\\Network\\Admin<\/strong><\/p>\n<p><strong>To:<\/strong><\/p>\n<p><strong>C:\\app\\client\\thakkn91\\product\\12.1.0\\client_1\\network\\admin<\/strong><\/p>\n<p><strong><em><u>Step 13<\/u><\/em><\/strong>\u00a0: Edit the \u201c<strong>System Environment Variables<\/strong>\u201d. Go to the control Pane and top search box search for environment click on Edit the System Environment Variables, click on Environment Variables go to\u00a0<strong>path<\/strong>\u00a0in System Variables. Make sure below Environment Variables are available if not copied in the Path folder.<\/p>\n<ul>\n<li>C:\\app\\client_12c_32\\product\\12.1.0\\client_1\\bin;<\/li>\n<\/ul>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFZ9DAylC_JzQ\/article-inline_image-shrink_1000_1488\/0\/1623710097727?e=1629331200&amp;v=beta&amp;t=xlTE_yldhXWLZJrfB9f7NX3nnuPYrGuiv_nvK8PwEKo\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFgIVbTb_hE1A\/article-inline_image-shrink_1000_1488\/0\/1623710124122?e=1629331200&amp;v=beta&amp;t=a8ZR6nBVX6V-kt5wEe1tV7hwfmRvC1oBDwlwtCGPX18\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 14<\/u><\/em><\/strong>\u00a0:\u00a0<strong>Test<\/strong>\u00a0the Connectivity to Oracle after 32 bit Install by running\u00a0<strong>SQLPLUS on CMD<\/strong>.<\/p>\n<p><strong>Command<\/strong>: \u2014 sqlplus<\/p>\n<p>User_Name\/Password@(Oracle Server Name)<\/p>\n<p><strong><em><u>Step 15<\/u><\/em><\/strong>\u00a0: Set up ODBC-64 Bit for Oracle Connectivity<\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQGRzFPDho2c2A\/article-inline_image-shrink_1000_1488\/0\/1623710148680?e=1629331200&amp;v=beta&amp;t=z9qUJuhxNLv-3NAzim185xYeuXg0JSuG5pYVadg9f1c\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQF7Z373hgq8gg\/article-inline_image-shrink_1000_1488\/0\/1623710159546?e=1629331200&amp;v=beta&amp;t=pXnwgC9sol4gnevxmZk-xwvq19JtZWy4b5EJOZsnQgc\" alt=\"No alt text provided for this image\" \/><\/div>\n<p><strong><em><u>Step 16<\/u><\/em><\/strong>\u00a0: Set up ODBC-32 Bit for Oracle Connectivity same as 64 Bit.<\/p>\n<p><strong><em><u>Step 17<\/u><\/em><\/strong>\u00a0: Set up\u00a0<strong>New Connection in SSIS<\/strong>\u00a0in Connection Managers for Oracle. Select Connection Manager type as\u00a0<strong>\u201cMSORA\u201d<\/strong><\/p>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQEKytnHTl7HrQ\/article-inline_image-shrink_1000_1488\/0\/1623710276549?e=1629331200&amp;v=beta&amp;t=d8KWOA_wJYrCNAZnbq6tuJXPyrQKRpCb3iuT2s-a7M8\" alt=\"No alt text provided for this image\" \/><\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQFMJVNEn5irpQ\/article-inline_image-shrink_1000_1488\/0\/1623710285594?e=1629331200&amp;v=beta&amp;t=OSLMSn-YrQxCAffqIGIco_3Qp1CqZIXXKxICLfsmkDk\" alt=\"No alt text provided for this image\" \/><\/div>\n<div>\u00a0<\/div>\n<div class=\"slate-resizable-image-embed slate-image-embed__resize-full-width\"><img decoding=\"async\" src=\"https:\/\/media-exp1.licdn.com\/dms\/image\/C5612AQEGjOk7RRThZQ\/article-inline_image-shrink_1000_1488\/0\/1623710294658?e=1629331200&amp;v=beta&amp;t=QJ7SgK58jlcWYC80GS01xGDJjbjg2ZuTTYPSRvtBwuM\" alt=\"No alt text provided for this image\" \/><\/div>\n<div>\u00a0<\/div>\n<div>You are all set ! Enjoy !!!<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Almost every environment now a days need to source data from different source system. Here is how you can establish connection using Attunity Connector from\u00a0Microsoft SQL Server to Oracle Database\u00a0 from SSIS. This method is extremely fast if you want to land millions and millions of records on the fly from Oracle to SQL Server&#8230;.&hellip;<\/p>\n","protected":false},"author":337362,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[143571,4170,5199,4151],"coauthors":[143570],"class_list":["post-91345","post","type-post","status-publish","format-standard","hentry","category-blogs","tag-attunity","tag-database-administration","tag-oracle-to-sql-server","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/91345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/337362"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=91345"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/91345\/revisions"}],"predecessor-version":[{"id":91349,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/91345\/revisions\/91349"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=91345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=91345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=91345"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=91345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}