From the SQL Management Studio (SSMS) there is a way to connect/create a linked server to a MariaDB. For this you would need the following.
– Install the ODBC Connector for MariaDB
– Create an ODBC Connection (System DSN)
– Add Linked Server.
Installing the ODBC libraries for MariaDB
Browse to https://mariadb.com/downloads/connectors/connectors-data-access/odbc-connector/
Download the required ODBC installer for Windows.
Install the downloaded “mariadb-connector-odbc-3.2.3-win64.msi” file
Creation of the ODBC connection
Open the ODBC Data Source Administrator (64-bit)
Click on System DSN
Click on Add
Select MariaDB ODBC 3.2 Driver
Give the connection a name
Enter the server details and click on Test DSN to confirm the connectivity.
Setting up the connection via the SSMS
Open the SQL Management Studio
Connect to the SQL instance
Click on Server Objects and right-click on Linked Servers
Click on New Linked Server
Enter a name in the linked server section
Change the Provider to Microsoft OLE DB Provider for ODBC Drivers
Enter the ODBC Connection name you created in the Data Source section
Click on Security
Click on Be made using this security context and enter the credentials of the MariaDB server
Click OK
This will create the connection and you can browse the data.
