File: C:/Program Files/MySQL/MySQL Workbench 8.0/modules/data/generic_rdbms_info.xml
<?xml version="1.0"?>
<data>
<value type="object" struct-name="db.mgmt.Rdbms" id="com.mysql.rdbms.generic">
<value type="string" key="caption">Generic RDBMS</value>
<value type="string" key="name">Generic</value>
<value type="string" key="databaseObjectPackage">db.generic</value>
<value type="int" key="maximumIdentifierLength">64</value>
<link type="object" key="defaultDriver">com.mysql.rdbms.generic.driver.odbc</link>
<value type="int" key="doesSupportCatalogs">1</value>
<!-- Privileges -->
<value type="list" content-type="object" content-struct-name="db.mgmt.PrivilegeMapping" key="privilegeNames">
</value>
<!-- Character Sets -->
<value type="list" content-type="object" content-struct-name="db.CharacterSet" key="characterSets">
</value>
<!-- Drivers -->
<value type="list" content-type="object" content-struct-name="db.mgmt.PythonDBAPIDriver" key="drivers">
<value type="object" struct-name="db.mgmt.PythonDBAPIDriver" id="com.mysql.rdbms.generic.driver.odbc">
<value type="string" key="caption">ODBC (manually entered parameters)</value>
<value type="string" key="description">Pyodbc ODBC Driver</value>
<value type="string" key="driverLibraryName">pyodbc</value>
<value type="string" key="connectionStringTemplate">DRIVER=%driver%;SERVER=%hostName%;PORT=%port%;DATABASE=%schema%;UID=%userName%;PWD=%password%;%extras%</value>
<value type="list" content-type="string" key="files">
<!--value type="string">libmysql.dll</value-->
</value>
<value type="string" key="hostIdentifierTemplate">generic@DRIVER=%driver%;SERVER=%hostName%;PORT=%port%</value>
<value type="string" key="filesTarget">.</value>
<value type="string" key="name">GenericOdbc</value>
<link type="object" key="owner">com.mysql.rdbms.generic</link>
<value type="list" content-type="object" content-struct-name="db.mgmt.DriverParameter" key="parameters">
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param6">
<value type="string" key="caption">Driver:</value>
<value type="string" key="accessibilityName">Driver</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The Driver name of your ODBC driver (E.g. FreeTDS, PostgreSQL).</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">2</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">driver</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">1</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param1">
<value type="string" key="caption">Hostname:</value>
<value type="string" key="accessibilityName">Host Name</value>
<value type="string" key="defaultValue">127.0.0.1</value>
<value type="string" key="description">Name or IP address of the server host.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">118</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">hostName</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">1</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param2">
<value type="string" key="caption">Port:</value>
<value type="string" key="accessibilityName">Port</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">TCP/IP port.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">46</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">port</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">int</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param3">
<value type="string" key="caption">Username:</value>
<value type="string" key="accessibilityName">User Name</value>
<value type="string" key="defaultValue">root</value>
<value type="string" key="description">Name of the user to connect with.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">2</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">userName</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param4">
<value type="string" key="caption">Password:</value>
<value type="string" key="accessibilityName">Password</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The user's password. Will be requested later if it's not set.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">3</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">password</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">keychain</value>
<value type="dict" content-type="string" key="paramTypeDetails">
<value type="string" key="storageKeyFormat">%userName%::Generic@%hostName%:%port%</value>
</value>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param5">
<value type="string" key="caption">Database:</value>
<value type="string" key="accessibilityName">Database</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The database to connect to. Leave blank to select it later.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">4</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">schema</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param6">
<value type="string" key="caption">Additional arguments</value>
<value type="string" key="accessibilityName">Additional arguments</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">; separated list of extra arguments to use in the
ODBC connection string.</value>
<value type="int" key="layoutAdvanced">1</value>
<value type="int" key="layoutRow">-1</value>
<value type="int" key="layoutWidth">318</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">extras</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
</value>
</value>
<value type="object" struct-name="db.mgmt.PythonDBAPIDriver" id="com.mysql.rdbms.generic.driver.odbc_dsn">
<value type="string" key="caption">ODBC Data Source</value>
<value type="string" key="description">Pyodbc ODBC Driver, using DSN</value>
<value type="string" key="driverLibraryName">pyodbc</value>
<value type="string" key="connectionStringTemplate">DSN=%dsn%</value>
<value type="list" content-type="string" key="files">
<!--value type="string">libmysql.dll</value-->
</value>
<value type="string" key="filesTarget">.</value>
<value type="string" key="name">GenericOdbcDSN</value>
<link type="object" key="owner">com.mysql.rdbms.generic</link>
<value type="list" content-type="object" content-struct-name="db.mgmt.DriverParameter" key="parameters">
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc_dsn.param1">
<value type="string" key="caption">DSN:</value>
<value type="string" key="accessibilityName">DSN</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">Pre-configured ODBC data source.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueModule">DbGenericRE</value>
<value type="string" key="lookupValueMethod">getDataSourceNames</value>
<value type="string" key="name">dsn</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc_dsn</link>
<value type="string" key="paramType">enum</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">1</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc_dsn.param2">
<value type="string" key="caption">Password:</value>
<value type="string" key="accessibilityName">Password</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The user's password. Will be requested later if it's not set.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">2</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">password</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc_dsn</link>
<value type="string" key="paramType">keychain</value>
<value type="dict" content-type="string" key="paramTypeDetails">
<value type="string" key="storageKeyFormat"><dsn user>::Generic@%dsn%</value>
</value>
<value type="int" key="required">0</value>
</value>
</value>
</value>
<value type="object" struct-name="db.mgmt.PythonDBAPIDriver" id="com.mysql.rdbms.generic.driver.odbc_connstr">
<value type="string" key="caption">ODBC (direct connection string)</value>
<value type="string" key="description">Pyodbc ODBC Driver</value>
<value type="string" key="driverLibraryName">pyodbc</value>
<value type="string" key="connectionStringTemplate">%connection_string%</value>
<value type="list" content-type="string" key="files">
<!--value type="string">libmysql.dll</value-->
</value>
<value type="string" key="hostIdentifierTemplate">generic@DRIVER=%driver%;SERVER=%hostName%;PORT=%port%</value>
<value type="string" key="filesTarget">.</value>
<value type="string" key="name">GenericOdbc</value>
<link type="object" key="owner">com.mysql.rdbms.generic</link>
<value type="list" content-type="object" content-struct-name="db.mgmt.DriverParameter" key="parameters">
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc_connstr.param1">
<value type="string" key="caption">Connection String:</value>
<value type="string" key="accessibilityName">Connection String</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The full ODBC connection string to use for the connection.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">connection_string</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc_connstr</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">1</value>
</value>
</value>
</value>
<!--value type="object" struct-name="db.mgmt.PythonDBAPIDriver" id="com.mysql.rdbms.generic.driver.sqlite">
<value type="string" key="caption">SQLite ODBC Driver</value>
<value type="string" key="description">Pyodbc ODBC Driver SQLite Connection</value>
<value type="string" key="driverLibraryName">pyodbc</value>
<value type="string" key="connectionStringTemplate">DRIVER=SQLITE3;DATABASE=%database%</value>
<value type="list" content-type="string" key="files">
</value>
<value type="string" key="filesTarget">.</value>
<value type="string" key="name">GenericSQLite</value>
<link type="object" key="owner">com.mysql.rdbms.generic</link>
<value type="list" content-type="object" content-struct-name="db.mgmt.DriverParameter" key="parameters">
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param1">
<value type="string" key="caption">Hostname:</value>
<value type="string" key="defaultValue">127.0.0.1</value>
<value type="string" key="description">Name or IP address of the server host</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">118</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">hostName</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">1</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param2">
<value type="string" key="caption">Port:</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">TCP/IP port</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">1</value>
<value type="int" key="layoutWidth">46</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">port</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">int</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param3">
<value type="string" key="caption">Username:</value>
<value type="string" key="defaultValue">root</value>
<value type="string" key="description">Name of the user to connect with.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">2</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">userName</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param4">
<value type="string" key="caption">Password:</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The user's password.</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">3</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">%userName%::Mssql@%hostName%:%port%</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">keychain</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
<value type="object" struct-name="db.mgmt.DriverParameter" id="com.mysql.rdbms.generic.driver.odbc.param5">
<value type="string" key="caption">Database:</value>
<value type="string" key="defaultValue"></value>
<value type="string" key="description">The database to connect to</value>
<value type="int" key="layoutAdvanced">0</value>
<value type="int" key="layoutRow">4</value>
<value type="int" key="layoutWidth">218</value>
<value type="string" key="lookupValueMethod"></value>
<value type="string" key="lookupValueModule"></value>
<value type="string" key="name">schema</value>
<link type="object" key="owner">com.mysql.rdbms.generic.driver.odbc</link>
<value type="string" key="paramType">string</value>
<value type="dict" content-type="string" key="paramTypeDetails"/>
<value type="int" key="required">0</value>
</value>
</value>
</value-->
</value>
<!-- Datatypes -->
<value type="list" content-type="object" content-struct-name="db.SimpleDatatype" key="simpleDatatypes">
</value>
</value>
</data>