Contents x
    Data Source - RDBMS Version Mapping
    • 06 Jan 2023
    • Print
    • Dark
      Light
    • PDF
    Contents

    Data Source - RDBMS Version Mapping

    • Updated on 06 Jan 2023
    • Print
    • Dark
      Light
    • 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?
    What's Next