{"id":15768,"date":"2022-04-05T17:09:35","date_gmt":"2022-04-05T21:09:35","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=15768"},"modified":"2022-04-05T17:09:35","modified_gmt":"2022-04-05T21:09:35","slug":"connecting-to-microsoft-access-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/connecting-to-microsoft-access-in-iri-workbench\/","title":{"rendered":"Connecting to Microsoft Access in IRI Workbench"},"content":{"rendered":"

Connecting the <\/span>Microsoft Access<\/span><\/a> database to <\/span>IRI Workbench<\/span><\/a> and the back-end <\/span>SortCL<\/span><\/a> data processing program to exploit the many data manipulation and management <\/span>capabilities<\/span><\/a> of Voracity platform software is a simple process. The method follows the same paradigm as other databases; see similar sets of instructions indexed <\/span>here<\/span><\/a>.<\/span><\/p>\n

To allow Workbench to view the tables and use the metadata in Access, you\u2019ll need a JDBC driver. And since SortCL is written in C, an ODBC driver is required to move the data to and from the engine.<\/span><\/p>\n

At the time of writing this article, Microsoft\u2019s ODBC driver for Access does not support certain functions SortCL requires, nor does Microsoft have a JDBC driver. We are therefore using partner JDBC and ODBC drivers from <\/span>CData<\/span><\/a>. A second option for JDBC drivers is <\/span>Ucanaccess<\/span><\/a>, which is an open-source driver implementation from SourceForge.<\/span><\/p>\n

Microsoft Access does not support the use of schemas. Using the CData driver, a schema <\/span>Access <\/span><\/i>is used as a placeholder that contains all the tables. Ucanaccess does the same thing but uses the name <\/span>Public <\/span><\/i>as the schema name.\u00a0<\/span><\/p>\n

Due to the way that CData is being used with a schema placeholder, it will always state that a connection is successful. To know if a connection is truly successful, check to see if the tables are viewable in the Data Source Explorer within Workbench.<\/span><\/p>\n

Known Driver Limitations<\/b><\/h6>\n

Using the data types <\/span>Large Number<\/span><\/i> and<\/span> Date & Time Extended <\/span><\/i>causes the Access database to no longer be compatible with earlier versions. This causes the drivers from both CData (version 21) and SourceForge (version 5.0.1) to no longer be able to connect to the database.\u00a0<\/span><\/p>\n

There is also a compatibility issue using CData\u2019s ODBC and SourceForge\u2019s JDBC driver due to both having different default schema names that are not configurable. Currently, Workbench is under development to add more support for SourceForge\u2019s JDBC driver.<\/span><\/p>\n

\"\"<\/p>\n

Setting Up ODBC<\/b><\/h6>\n

Now that the drivers have been downloaded and the limitations are understood, the next step is to set up the ODBC Connection. Open the ODBC Data Source Administrator application (which can be found easily using Windows search).\u00a0<\/span><\/p>\n

There are two versions for this application, one that is 32-bit and the other 64-bit. Select the one that corresponds to the bit version of SortCL, which is found in the Workbench Help menu under Version Information.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

In the ODBC Data Source Administrator, under the User DSN or System DSN tab, click the <\/span>Add\u2026 <\/span><\/i>button and select the \u201c<\/span>CData ODBC Driver for Access<\/span><\/i>\u201d driver.\u00a0<\/span><\/p>\n

The CDData driver configuration page will open to the Connection tab. Name the Data Source, which can correspond to the name of your Access database to provide context.\u00a0<\/span><\/p>\n

The only thing that is required is the path to where the Access database (.accdb) file is located. Test the connection, and if everything is successful the next step is to set up the JDBC connection inside of Workbench.<\/span><\/p>\n

\"\"<\/p>\n

Setting Up JDBC<\/b><\/h6>\n

In the lower-left corner of IRI Workbench, the Data Source Explorer view should be open. Click on the gold icon called \u201c<\/span>New Connection Profile<\/span><\/i>\u201d and a pop-up window will appear with all the RDB sources that IRI Workbench supports \u201cout of the box.\u201d<\/span><\/p>\n

\"\"<\/p>\n

The following display is where the driver definitions and jar files are configured. Select the driver template relevant to the JDBC driver that will be used. The default driver is Ucanaccess. Once the driver template is selected go to the JAR List tab to input the path to the jars needed.<\/span><\/p>\n

\"\"<\/p>\n

The image below shows the list of jars that are needed for Ucanaccess. All that is required from the user is to give the path to the jar files, which can be done by selecting the <\/span>Edit Jar\/Zip\u2026 <\/span><\/i>button.<\/span><\/p>\n

\"\"<\/p>\n

The image below shows the same Jar List requirements, but for CData with the path already loaded in.<\/span><\/p>\n

\"\"<\/p>\n

Once the driver template is selected and the required jar files have their full path, click OK. This returns to the New Connection Profile, and requires the location to the Access database file.\u00a0<\/span><\/p>\n

There are optional parameters like user name and password (if needed to connect to Access). In this case, no credentials were needed. Test your connection to ensure the information is correct.<\/span><\/p>\n

\"\"<\/p>\n

Setting Up Data Connection Registry<\/b><\/h6>\n

The final step is to set up the connection registry that essentially creates the relationship between ODBC and JDBC drivers. From the Workbench top toolbar, open the IRI menu and Preferences. From there, select IRI > Data Connection Registry.\u00a0<\/span><\/p>\n

\"\"<\/p>\n

Within the Data Connection Registry, the DSN column relates to the ODBC driver, so look for the name of the <\/span>Access<\/span><\/i> data source you set up earlier. Select the name and click on the<\/span> Edit \u2026<\/span><\/i> button on the right to add the missing information.<\/span><\/p>\n

The Data Connection Registry options dialog that appears will contain information on the DSN. Below that, you can select which bit version to use, and at the very bottom is where you select the connection profile that corresponds to your JDBC driver setup (and connection name in\u00a0 Data Source Explorer).\u00a0<\/span><\/p>\n

\"\"<\/p>\n

Select from the drop-down menu the Access connection profile and add any necessary authentication information. Select OK to save all the information.<\/span><\/p>\n

Your Access database should now be available for use in <\/span>IRI Voracity<\/span><\/a>-related structured data management tasks supported in IRI Workbench. If you need assistance, please contact your <\/span>IRI representative<\/span><\/a> or email <\/span>support@iri.com<\/span><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process. The method follows the same paradigm as other databases; see similar sets of instructions indexed here. To allow Workbench to view the tables<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":160,"featured_media":15775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[31,91,3],"tags":[1647,1681,1062,1862,1864,789,850,956,1682,1863,75],"class_list":["post-15768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-migration","category-iri-workbench","category-vldb-operations","tag-cdata","tag-connect-microsoft-access","tag-data-connection-registry","tag-data-integration-tools","tag-data-masking-in-access","tag-iri-voracity","tag-iri-workbench","tag-jdbc","tag-microsoft-access","tag-ms-access-integration","tag-odbc"],"acf":[],"yoast_head":"\nConnecting to Microsoft Access in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.\" \/>\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.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting to Microsoft Access in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-05T21:09:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"396\" \/>\n\t<meta property=\"og:image:height\" content=\"161\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kevin Roldos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin Roldos\" \/>\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.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\"},\"author\":{\"name\":\"Kevin Roldos\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\"},\"headline\":\"Connecting to Microsoft Access in IRI Workbench\",\"datePublished\":\"2022-04-05T21:09:35+00:00\",\"dateModified\":\"2022-04-05T21:09:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\"},\"wordCount\":907,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg\",\"keywords\":[\"CData\",\"Connect Microsoft Access\",\"Data Connection Registry\",\"data integration tools\",\"data masking in access\",\"IRI Voracity\",\"IRI Workbench\",\"JDBC\",\"Microsoft Access\",\"MS Access integration\",\"ODBC\"],\"articleSection\":[\"Data Migration\",\"IRI Workbench\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\",\"name\":\"Connecting to Microsoft Access in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg\",\"datePublished\":\"2022-04-05T21:09:35+00:00\",\"dateModified\":\"2022-04-05T21:09:35+00:00\",\"description\":\"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg\",\"width\":396,\"height\":161},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting to Microsoft Access in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\",\"name\":\"Kevin Roldos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g\",\"caption\":\"Kevin Roldos\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/kevinr\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecting to Microsoft Access in IRI Workbench - IRI","description":"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.","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.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Connecting to Microsoft Access in IRI Workbench","og_description":"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2022-04-05T21:09:35+00:00","og_image":[{"width":396,"height":161,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","type":"image\/jpeg"}],"author":"Kevin Roldos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Roldos","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/"},"author":{"name":"Kevin Roldos","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0"},"headline":"Connecting to Microsoft Access in IRI Workbench","datePublished":"2022-04-05T21:09:35+00:00","dateModified":"2022-04-05T21:09:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/"},"wordCount":907,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","keywords":["CData","Connect Microsoft Access","Data Connection Registry","data integration tools","data masking in access","IRI Voracity","IRI Workbench","JDBC","Microsoft Access","MS Access integration","ODBC"],"articleSection":["Data Migration","IRI Workbench","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/","name":"Connecting to Microsoft Access in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","datePublished":"2022-04-05T21:09:35+00:00","dateModified":"2022-04-05T21:09:35+00:00","description":"Connecting the Microsoft Access database to IRI Workbench and the back-end SortCL data processing program to exploit the many data manipulation and management capabilities of Voracity platform software is a simple process.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","width":396,"height":161},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/connecting-to-microsoft-access-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting to Microsoft Access in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0","name":"Kevin Roldos","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a592c9c38829637b969040dd5247c4be?s=96&d=blank&r=g","caption":"Kevin Roldos"},"url":"https:\/\/www.iri.com\/blog\/author\/kevinr\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Main-Image-MsAccess.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15768"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/160"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=15768"}],"version-history":[{"count":7,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15768\/revisions"}],"predecessor-version":[{"id":17789,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15768\/revisions\/17789"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/15775"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=15768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=15768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=15768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}