Data Source - RDBMS Version Mapping
  • 06 Jan 2023
  • PDF

Data Source - RDBMS Version Mapping

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This is a correspondence table of supported versions of the transfer source RDBMS.

Transferfromembulkplugin supportversiontrocco supportversionremarks
mysql5(MySQL Connector/J 5.1.44)5, 8Authentication methods added from 8.0: caching_sha2_password is not supported
sqlserverjTDS Driver 1.3.1
Microsoft's JDBC Driver
jTDS Driver 1.3.1
Microsoft SQLServer JDBC Driver 8.2
DB Version Comparison Table
postgresqlPostgreSQL JDBC Driver 9.4-1205The following two versions are supported.
  • PostgreSQL JDBC Driver 9.4-1205
  • PostgreSQL JDBC Driver 42.5.1
-
oracleGet and configure the JDBC driver from the officialThe corresponding JDBC jar files and Oracle Database versions are as follows.

  • ojdbc7.jar
    • 12.1 or 12cR1
  • ojdbc8.jar
    • 12.2 or 12cR2
    • 18.x
    • 19.x
    • 21.x
Correspondence table
db2UninvestigatedTROCCO not supportedUninvestigated
redshiftorg.postgresql:postgresql:9.4-1205-jdbc41Same to leftUses the same drivers as PostgreSQL

Reference https://github.com/embulk/embulk-input-jdbc/
*1 jTDS Driver http://jtds.sourceforge.net/ supports SQLServer 2012.
If you have any questions about the version, please contact your CS representative.

supplement

SQLServer Version Compatibility (Quoted from an external page)
https://docs.microsoft.com/ja-jp/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15#sql-version-compatibility

SQL Server 2019 SQL

DB Version →
↓ Driver
VersionAzure SQL DatabaseAzure Synapse AnalyticsAzure SQL Managed InstanceServer 2017SQLServer 2016SQL Server 2014SQL Server 2012PDW 2008R2 AU34SQL Server 2008 R2SQL Server 2008
9.2YesYesYesYesYesYesYesYes


8.4YesYesYesYesYesYesYesYesYes

8.2YesYesYesYesYesYesYesYesYes

7.4YesYesYesYesYesYesYesYesYes

7.2YesYesYes
YesYesYesYesYesYes
7YesYesYes
YesYesYesYesYesYes
6.4YesYesYes
YesYesYesYesYesYes
6.2YesYes

YesYesYesYesYesYesYes
6.1Yes



YesYesYesYesYesYes
6Yes



YesYesYesYesYesYes
4.2Yes



YesYesYesYesYesYes
4.1Yes



YesYesYesYesYesYes
4Yes



YesYesYesYesYesYes
3Yes*2




※5Yes*1
YesYes
2








※3※3
1.2









※3
  1. Microsoft SQL Server JDBC Driver version 3.0 allows you to connect to SQL Server 2012 on downstream clients.
  2. The 3.0 driver introduces support for Azure SQL Database as a hotfix. Azure SQL Database customers are encouraged to use the latest version of the driver.
  3. Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 allow you to connect to SQL Server 2008 on subordinate clients. If widening is allowed, the application can query and update new SQL Server 2008 data types, such as time, date, datetime2, datetimeoffset, and FILESTREAM. For more information about backward compatibility of these new data types, see the Working with Date and Time Data and FILESTREAM Support topics in SQL Server Books Online.
  4. Support for connections between the Microsoft JDBC Driver and parallel data warehouses was first introduced in Microsoft JDBC Driver 4.0 for SQL Server and Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance Update 3.
  5. Microsoft SQL Server JDBC Driver version 3.0 allows you to connect to SQL Server 2014 on downstream clients.

Was this article helpful?