{"id":16531,"date":"2023-07-21T21:43:09","date_gmt":"2023-07-22T01:43:09","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=16531"},"modified":"2023-12-08T10:24:19","modified_gmt":"2023-12-08T15:24:19","slug":"connecting-mariadb-and-mysql-to-iri-workbench","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/","title":{"rendered":"Connecting MariaDB and MySQL to IRI Workbench"},"content":{"rendered":"<p><a href=\"https:\/\/www.iri.com\/solutions\/database-acceleration\/mysql\"><span style=\"font-weight: 400;\">MariaDB and MySQL<\/span><\/a><span style=\"font-weight: 400;\"> are relational databases that follow the same paradigm when it comes to setting up connections with <\/span><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\"><span style=\"font-weight: 400;\">SortCL<\/span><\/a><span style=\"font-weight: 400;\">-driven Voracity <\/span><a href=\"https:\/\/www.iri.com\/products\/voracity\/technical-details#components\"><span style=\"font-weight: 400;\">component<\/span><\/a><span style=\"font-weight: 400;\"> jobs designed in <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\">. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform CoSort, FieldShield, NextForm, or RowGen jobs such as data transformation, obfuscation, migration, synthesis, reporting, etc. Note that if you are using DarkShield, only the JDBC connection is required.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Since MariaDB is a fork based on MySQL, the setups will be very similar, though there are some minor differences that this article will mention.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Note<\/span><span style=\"font-weight: 400;\">: Due to how similar both databases are to each other, you can reuse drivers (ODBC\/JDBC) for either database. This means that you can use a MySQL JDBC driver to connect to MariaDB but you have to make sure that the version you are using is <\/span><a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-vs-mysql-compatibility\/\"><span style=\"font-weight: 400;\">compatible<\/span><\/a><span style=\"font-weight: 400;\"> with the version of the database.<\/span><\/p>\n<p style=\"text-align: center;\"><strong>Follow along with our YouTube video!<\/strong><\/p>\n<p><iframe loading=\"lazy\" title=\"MySQL DB Tutorial\" width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/qcKDT8z6o5Q?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/p>\n<h4><b>ODBC Connection<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">First, download the ODBC driver for either <\/span><a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-odbc\/\"><span style=\"font-weight: 400;\">MariaDB <\/span><\/a><span style=\"font-weight: 400;\">or <\/span><a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/\"><span style=\"font-weight: 400;\">MySQL<\/span><\/a><span style=\"font-weight: 400;\">. Make sure to download the driver that is compatible with your OS version and that the bit version (32 bit or 64 bit) is the same as the CoSort bit version.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you do not know which CoSort (SortCL) bit version you have installed, open Workbench, select the <\/span><i><span style=\"font-weight: 400;\">Help <\/span><\/i><span style=\"font-weight: 400;\">tab, select <\/span><i><span style=\"font-weight: 400;\">Version Information<\/span><\/i><span style=\"font-weight: 400;\"> and here you will see which bit version you have. The example below shows a 32 bit version.<\/span><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16538 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/CoSort-bit-version-300x107.png\" alt=\"\" width=\"451\" height=\"161\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/CoSort-bit-version-300x107.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/CoSort-bit-version.png 727w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><span style=\"font-weight: 400;\">Run the ODBC .msi file you just downloaded and follow the instructions of the wizard. Once that is complete, you can create an ODBC connection to either database. Use the Windows search function to open the <\/span><i><span style=\"font-weight: 400;\">ODBC Data Source Administrator (64-bit) or (32-bit)<\/span><\/i><span style=\"font-weight: 400;\"> to create the connection.<\/span><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-16539 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/ODBC-Data-Source-Administrator-300x220.png\" alt=\"\" width=\"548\" height=\"402\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/ODBC-Data-Source-Administrator-300x220.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/ODBC-Data-Source-Administrator.png 502w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><span style=\"font-weight: 400;\">Select the <\/span><i><span style=\"font-weight: 400;\">Add\u2026<\/span><\/i><span style=\"font-weight: 400;\"> button and search for the data source you want to connect to. Once you click on Finish, another dialog will appear to input the connection credentials for your database. MySQL and MariaDB are slightly different, so the first connection shown below will be for MariaDB, and then followed by MySQL.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16541\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-connection-credentials-300x231.png\" alt=\"\" width=\"457\" height=\"352\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-connection-credentials-300x231.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-connection-credentials-768x590.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-connection-credentials.png 778w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The first page for MariaDB is asking for a name for the ODBC connection and a description <\/span><i><span style=\"font-weight: 400;\">(optional)<\/span><\/i><span style=\"font-weight: 400;\">. Once you\u2019ve given a name select <\/span><i><span style=\"font-weight: 400;\">Next &gt;<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16543\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-to-MariaDB-300x220.png\" alt=\"\" width=\"464\" height=\"340\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-to-MariaDB-300x220.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-to-MariaDB.png 502w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">On the next page, you will specify the server name and the port on which it is listening; the default is port 3306. In the middle of the dialog, you can add the credentials to connect to your database and test to see if the connection is working.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16544 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP-300x190.png\" alt=\"\" width=\"431\" height=\"273\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP-300x190.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP-1024x648.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP-768x486.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP-1536x973.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MariaDB-TCPIP.png 1745w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">If you select the <\/span><i><span style=\"font-weight: 400;\">Test DSN<\/span><\/i><span style=\"font-weight: 400;\">, a successful connection will look like this:<\/span><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-16545 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Connection-test-300x86.png\" alt=\"\" width=\"422\" height=\"121\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Connection-test-300x86.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Connection-test-1024x294.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Connection-test-768x220.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Connection-test-1536x441.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Connection-test.png 1634w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The following pages allow you to set up <\/span><span style=\"font-weight: 400;\">optional<\/span><span style=\"font-weight: 400;\"> configurations such as:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">TLS Settings<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQL Queries\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Server Sessions<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cursor\/Results<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Once everything is set up to your liking and the test DSN is successful, click the Finish button to make your ODBC connection ready for use.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">MySQL will be the same except that its dialog and optional configuration is limited and simple. Again you will need the following information: a name for the connection, the server name or IP address, the port number, and credentials to connect to the database.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16547\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials-300x297.png\" alt=\"\" width=\"353\" height=\"350\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials-300x297.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials-150x150.png 150w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials-768x761.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials-70x70.png 70w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mysql-credentials.png 777w\" sizes=\"(max-width: 353px) 100vw, 353px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Test the connection to ensure that everything is working properly and then click <\/span><i><span style=\"font-weight: 400;\">OK<\/span><\/i><span style=\"font-weight: 400;\"> to save the configuration. The next step is to create a JDBC connection inside of\u00a0 Workbench.<\/span><\/p>\n<h4><b>JDBC Connection<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">As with ODBC, you need to download the JDBC driver for either <\/span><a href=\"https:\/\/mariadb.com\/kb\/en\/installing-mariadb-connectorj\/\"><span style=\"font-weight: 400;\">MariaDB<\/span><\/a><span style=\"font-weight: 400;\"> or <\/span><a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/j\/\"><span style=\"font-weight: 400;\">MySQL<\/span><\/a><span style=\"font-weight: 400;\">. However, instead of being used for data movement between the database and SortCL <span id='easy-footnote-1-16531' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#easy-footnote-bottom-1-16531' title='\u00a0Note that the JDBC driver &lt;i&gt;is &lt;\/i&gt;also used for data movement when using IRI DarkShield for masking. See &lt;a href=&quot;https:\/\/www.iri.com\/company\/faqs\/190&quot;&gt;this FAQ&lt;\/a&gt; to understand the differences between masking RDB data with FieldShield\/SortCL vs. DarkShield.'><sup>1<\/sup><\/a><\/span><\/span><span style=\"font-weight: 400;\">, the JDBC driver enables table interactivity and DDL metadata interchange in IRI Workbench. Again be sure to download the version compatible with your O\/S.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the <\/span><i><span style=\"font-weight: 400;\">Data Source Explorer<\/span><\/i><span style=\"font-weight: 400;\"> section, select the new connection profile icon <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16548\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/icon1.png\" alt=\"\" width=\"31\" height=\"27\" \/> <\/span><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16551\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-300x184.png\" alt=\"\" width=\"344\" height=\"211\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-300x184.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-1024x626.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source-768x470.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Data-Source.png 1110w\" sizes=\"(max-width: 344px) 100vw, 344px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The <\/span><i><span style=\"font-weight: 400;\">New Connection Profile<\/span><\/i><span style=\"font-weight: 400;\"> dialog will appear. You can select the MySQL profile for either MySQL or MariaDB. Overwrite the default name for the profile to one that gives context to what you are connecting to.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16554\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/NewConnectionProfileMsql-262x300.png\" alt=\"\" width=\"408\" height=\"468\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/NewConnectionProfileMsql-262x300.png 262w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/NewConnectionProfileMsql.png 764w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select <\/span><i><span style=\"font-weight: 400;\">Next &gt; <\/span><\/i><span style=\"font-weight: 400;\">and an empty page will appear. To the right of the <\/span><i><span style=\"font-weight: 400;\">Drivers <\/span><\/i><span style=\"font-weight: 400;\">drop-down menu, click on the wheel icon called <\/span><i><span style=\"font-weight: 400;\">New Driver Definition<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16555\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/New-Driver-Definition-300x72.png\" alt=\"\" width=\"492\" height=\"118\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/New-Driver-Definition-300x72.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/New-Driver-Definition-1024x245.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/New-Driver-Definition-768x184.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/New-Driver-Definition.png 1523w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">This will open a new dialog to select a driver version; look for the one that corresponds to your database version or use the latest version. You can name the driver version to add context if the driver is connecting to MariaDB or MySQL.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16556\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/select-driver-version-300x252.png\" alt=\"\" width=\"425\" height=\"357\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/select-driver-version-300x252.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/select-driver-version-768x645.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/select-driver-version.png 955w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select the <\/span><i><span style=\"font-weight: 400;\">JAR List<\/span><\/i><span style=\"font-weight: 400;\"> tab and here is where you can add the path to the JDBC jar file you downloaded. As the image below shows, there is already a jar file with no path which you can simply remove or edit to the path of your .jar file.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16557\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/JAR-List-tab-300x147.png\" alt=\"\" width=\"510\" height=\"250\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JAR-List-tab-300x147.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JAR-List-tab-1024x501.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JAR-List-tab-768x376.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JAR-List-tab.png 1433w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Next, select the <\/span><i><span style=\"font-weight: 400;\">Properties <\/span><\/i><span style=\"font-weight: 400;\">tab, and here is where MariaDB and MySQL differ. For MySQL, all you need to do is change the Connection URL to contain the server name or IP address, the port number if it&#8217;s not the default 3306, and the database name.<\/span><\/p>\n<p><strong>Syntax<\/strong><\/p>\n<p><i><span style=\"font-weight: 400;\">jdbc:mysql:\/\/&lt;serverName\/IpAddress&gt;:portNumber\/databaseName<\/span><\/i><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16558\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-300x143.png\" alt=\"\" width=\"487\" height=\"232\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-300x143.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-1024x487.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-768x365.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-1536x730.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-1110x530.png 1110w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab-730x350.png 730w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Properties-Tab.png 1808w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Below the connection URL, add the name of the database. Add the credentials to connect to the database at the bottom.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For MariaDB the connection URL and the driver class are different. Edit the connection URL to start with <\/span><b><i>jdbc:mariadb:\/\/ <\/i><\/b><span style=\"font-weight: 400;\">and the rest is the same syntax as above. Next change the driver class to <\/span><b><i>org.mariadb.jdbc.Driver<\/i><\/b><span style=\"font-weight: 400;\"> for the connection to work. The same goes for MySQL; you need to add the credentials and specify the database name.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16560\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver-300x139.png\" alt=\"\" width=\"477\" height=\"221\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver-300x139.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver-1024x473.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver-768x355.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver-1536x710.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/mariadb-jdbc-driver.png 1649w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select <\/span><i><span style=\"font-weight: 400;\">OK<\/span><\/i><span style=\"font-weight: 400;\"> and now you are back to the connection profile. Ensure that the information is populating correctly with the name of the database, the correct connection URL, and the credentials.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select the <\/span><i><span style=\"font-weight: 400;\">Save password<\/span><\/i><span style=\"font-weight: 400;\"> to avoid having to give the password every time you need to connect to your data source and finally select the <\/span><i><span style=\"font-weight: 400;\">Test Connection<\/span><\/i><span style=\"font-weight: 400;\"> at the lower right section to ensure everything is working correctly.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16561\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Test-Connection-261x300.png\" alt=\"\" width=\"389\" height=\"447\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Test-Connection-261x300.png 261w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Test-Connection.png 701w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Click on <\/span><i><span style=\"font-weight: 400;\">Finish<\/span><\/i><span style=\"font-weight: 400;\"> if everything is correct and now you have a JDBC connection ready for use. If you run into errors, verify the connection URL is in the correct format for MariaDB or MySQL. The last step is to set up the database connection registry which maps the JDBC connection to the ODBC connection.<\/span><\/p>\n<h4><b>Database Connection Registry<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">From the Workbench top toolbar, click on the twistie (down arrow) next to the <\/span><i><span style=\"font-weight: 400;\">IRI Menu<\/span><\/i><span style=\"font-weight: 400;\">, which is located at the top, just under the <\/span><i><span style=\"font-weight: 400;\">Project<\/span><\/i><span style=\"font-weight: 400;\"> menu. Select the <\/span><i><span style=\"font-weight: 400;\">IRI Preferences\u2026 <\/span><\/i><span style=\"font-weight: 400;\">to set up the connection registry.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16562\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/IRI-Preferences-300x175.png\" alt=\"\" width=\"346\" height=\"202\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/IRI-Preferences-300x175.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/IRI-Preferences-1024x598.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/IRI-Preferences-768x448.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/IRI-Preferences.png 1244w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select the twistie next to IRI to see more information, then click the twistie next to <\/span><i><span style=\"font-weight: 400;\">Connection Registry, <\/span><\/i><span style=\"font-weight: 400;\">and then select <\/span><i><span style=\"font-weight: 400;\">Database Connection<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16563\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/Database-connection-300x155.png\" alt=\"\" width=\"586\" height=\"303\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Database-connection-300x155.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Database-connection-1024x529.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Database-connection-768x397.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/Database-connection.png 1110w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">There is a <\/span><i><span style=\"font-weight: 400;\">Default bit version:<\/span><\/i><span style=\"font-weight: 400;\"> it can be 32 or 64. Make sure that the bit version corresponds to the bit version of CoSort (the SortCL executable) and the ODBC connection you just created. Click the Refresh button to ensure Workbench can see all your available ODBC connections.\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Double-click on the ODBC connection you created to edit the registry. The <\/span><i><span style=\"font-weight: 400;\">Database Connection Dialog<\/span><\/i><span style=\"font-weight: 400;\"> will appear and at the top, you will see the ODBC information. In the middle make sure that the bit version is correct and below that, credentials to connect the database are specified.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To the right of both <\/span><i><span style=\"font-weight: 400;\">user <\/span><\/i><span style=\"font-weight: 400;\">and <\/span><i><span style=\"font-weight: 400;\">password, <\/span><\/i><span style=\"font-weight: 400;\">you can encrypt your credentials. It is recommended you at least encrypt your password. If you do not, when Workbench builds applicable SortCL jobs, your database credentials in the \/INFILE or \/OUTFILE section of script will be in plain text <span id='easy-footnote-2-16531' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#easy-footnote-bottom-2-16531' title='See &lt;a href=&quot;https:\/\/www.iri.com\/blog\/vldb-operations\/dsn-files-and-iri-software\/&quot;&gt;this article&lt;\/a&gt; on using DSN files to alternatively hide (and centralize) ODBC connection credentials.'><sup>2<\/sup><\/a><\/span>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">At the bottom of the dialog is where you can select the JDBC connection to map to. Select the drop-down menu and the JDBC connection you just created. Once you are done, the registry view should appear like this:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16566\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/JDBC-connection-248x300.png\" alt=\"\" width=\"370\" height=\"448\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JDBC-connection-248x300.png 248w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/JDBC-connection.png 677w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Click <\/span><i><span style=\"font-weight: 400;\">OK<\/span><\/i><span style=\"font-weight: 400;\"> and make sure that the connection is active. Again it should look like the image below:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16567\" src=\"\/blog\/wp-content\/uploads\/2023\/07\/final-setup-MariaDB-300x55.png\" alt=\"\" width=\"502\" height=\"92\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/final-setup-MariaDB-300x55.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/final-setup-MariaDB-1024x186.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/final-setup-MariaDB-768x140.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/final-setup-MariaDB.png 1110w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You have successfully set up Workbench (and the SortCL data processing program) to interact with your data source. If you need any help, please email <\/span><a href=\"mailto:support@iri.com\"><span style=\"font-weight: 400;\">support@iri.com<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform CoSort, FieldShield, NextForm, or RowGen jobs such as data<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\" title=\"Connecting MariaDB and MySQL to IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":160,"featured_media":16572,"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":[8,31,776,91,29,3],"tags":[77,13,850,1713,974,88,24],"class_list":["post-16531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-data-migration","category-etl","category-iri-workbench","category-test-data","category-vldb-operations","tag-data-migration-2","tag-data-protection-2","tag-iri-workbench","tag-mariadb","tag-mysql","tag-test-data-2","tag-vldb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connecting MariaDB and MySQL to IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting MariaDB and MySQL to IRI Workbench - IRI\" \/>\n<meta property=\"og:description\" content=\"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T01:43:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-08T15:24:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"368\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\"},\"author\":{\"name\":\"Kevin Roldos\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\"},\"headline\":\"Connecting MariaDB and MySQL to IRI Workbench\",\"datePublished\":\"2023-07-22T01:43:09+00:00\",\"dateModified\":\"2023-12-08T15:24:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\"},\"wordCount\":1391,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png\",\"keywords\":[\"data migration\",\"data protection\",\"IRI Workbench\",\"MariaDB\",\"MySQL\",\"test data\",\"VLDB\"],\"articleSection\":[\"Data Masking\/Protection\",\"Data Migration\",\"ETL\",\"IRI Workbench\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\",\"name\":\"Connecting MariaDB and MySQL to IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png\",\"datePublished\":\"2023-07-22T01:43:09+00:00\",\"dateModified\":\"2023-12-08T15:24:19+00:00\",\"description\":\"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png\",\"width\":768,\"height\":368},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting MariaDB and MySQL to IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.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:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0\",\"name\":\"Kevin Roldos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.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:\/\/beta.iri.com\/blog\/author\/kevinr\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting MariaDB and MySQL to IRI Workbench - IRI","description":"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.","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:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Connecting MariaDB and MySQL to IRI Workbench - IRI","og_description":"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.","og_url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/","og_site_name":"IRI","article_published_time":"2023-07-22T01:43:09+00:00","article_modified_time":"2023-12-08T15:24:19+00:00","og_image":[{"width":768,"height":368,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","type":"image\/png"}],"author":"Kevin Roldos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kevin Roldos","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/"},"author":{"name":"Kevin Roldos","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0"},"headline":"Connecting MariaDB and MySQL to IRI Workbench","datePublished":"2023-07-22T01:43:09+00:00","dateModified":"2023-12-08T15:24:19+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/"},"wordCount":1391,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","keywords":["data migration","data protection","IRI Workbench","MariaDB","MySQL","test data","VLDB"],"articleSection":["Data Masking\/Protection","Data Migration","ETL","IRI Workbench","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/","url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/","name":"Connecting MariaDB and MySQL to IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","datePublished":"2023-07-22T01:43:09+00:00","dateModified":"2023-12-08T15:24:19+00:00","description":"MariaDB and MySQL are relational databases that follow the same paradigm when it comes to setting up connections with SortCL-driven Voracity component jobs designed in IRI Workbench. Both JDBC (for IRI Workbench interaction) and ODBC (for data movement) must be set up before SortCL can perform jobs such as data obfuscation, data synthesis, data integration, etc.","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","width":768,"height":368},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/connecting-mariadb-and-mysql-to-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting MariaDB and MySQL to IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.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:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/03b00a019a87dc6f63f49782a08467a0","name":"Kevin Roldos","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.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:\/\/beta.iri.com\/blog\/author\/kevinr\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2023\/07\/MySQL-MariaDB-IRI.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/16531"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/160"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=16531"}],"version-history":[{"count":23,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/16531\/revisions"}],"predecessor-version":[{"id":17787,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/16531\/revisions\/17787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/16572"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=16531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=16531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=16531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}