What kind of data sources are supported by Dr.Sum EA Ver.4.1/4.2?

The following data sources can be used with the data import functions of Dr.Sum EA Ver. 4.1 and Ver. 4.2.

Usable Data Sources (*1)

  • ODBC connection database (*2) (*3) (*5)
  • JDBC connection database (*2) (*3) (*5) (*6)
  • OCI connection (Oracle Database 10g R2 or later, 64-bit edition only) (*2) (*3) (*4)
  • Excel file (*7)
  • CSV File
 
(*1)Versions of connection database, driver, OS, and JDK (if using JDBC) must be not only compatible with Dr.Sum EA products but also mutually compatible with each other.
Please check your operating environment and then confirm support requirements with each vendor individually.
(*2)The Extended Data Type added to Oracle 12c is not supported.
(*3)When acquiring object list information by connecting to Oracle Database in VTB Creator, public synonyms cannot be acquired.
(*4)For OCI connections, the versions of OCI and Oracle Database must be a combination that is supported by Oracle.
Also, for connections to Oracle 12c, if there is a VARCHAR2 that has a string over 4001 bytes in the reference Oracle, the import fails.
(*5)For the following data formats in PostgreSQL, mapping to a data format other than VARCHAR during import to Dr.Sum EA results in a format error:
・ money
・ timestamp with time zone
・ time with time zone
(*6)When connecting to PostgreSQL with JDBC, the value of real type may not be acquired accurately, resulting in a slight difference.
(*7)The following Excel formats are supported:
・XLS Format: Excel 97-2003 Workbook
・XLSX Format: “Excel Workbook,” “Strict Open XML Spreadsheet”
・XLSM Format: “Excel Macro-Enabled Workbook”


The following data sources have connections verified by us: Please use as reference information.

Data Sources with Verified Connections
* Operation with ODBC, JDBC, and OCI has been confirmed for the 64-bit edition.
* Data is current as of April 21st, 2016. Please be advised that this information may change.
 

Connection Method

Connection-verified Data Source

ODBC

SQL Server 2014、2016 (*8)
IBM DB2 10.5
Oracle 11g R2, 12c
PostgreSQL 9.3
MySQL 5.6
IBM DB2 for i (AS/400) (*9) V6R1, V7R1, V7R2

JDBC

SQL Server 2014, 2016 (*8)
IBM DB2 10.5
Oracle 11g R2, 12c
PostgreSQL 9.3
MySQL 5.6
IBM DB2 for i (AS/400) (*9) V6R1, V7R1, V7R2
OCI8Oracle 11g R2, 12c

Excel

The following Excel formats:
・XLS Format: “Excel 97-2003 Workbook”
・XLSX Format: “Excel Workbook,” “Strict Open XML Spreadsheet”
・XLSM Format: “Excel Macro-Enabled Workbook”
CSVText file in CSV format
 
(*8)The operation of Dr.Sum EA 4.2.00.0003 was checked.
(*9)Supported by Dr.Sum EA 4.2.00.0003.

(Updated on December 8th, 2016)