KB#: 000016572
Last Updated: 1/Jun/2020
The following data sources can be used with the data import functions of Dr.Sum Ver. 5.5.
Usable Data Sources (*1)
- ODBC connection database (*2) (*3) (*5)
- JDBC connection database (*2) (*3) (*5) (*6)
- OCI connection (Oracle Database 10gR2 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.
* This list is updated on Jun 1st, 2020. It's subject to change.
Connection Method |
Connection-verified Data Source |
ODBC |
SQL Server 2014, 2016, 2017, 2019 |
IBM DB2 10.5, 11.1, 11.5 | |
Oracle 11gR2, 12cR2, 18c, 19c | |
PostgreSQL 9.6 | |
MySQL 5.7 | |
IBM DB2 for i(AS/400) V6R1, V7R1, V7R2, V7R3 | |
JDBC |
SQL Server 2014, 2016, 2017, 2019 |
IBM DB2 10.5, 11.1, 11.5 | |
Oracle 11gR2, 12cR2, 18c, 19c | |
PostgreSQL 9.6 | |
MySQL 5.7 | |
IBM DB2 for i(AS/400) V6R1, V7R1, V7R2, V7R3 | |
OCI8 | Oracle 11gR2, 12cR2, 18c, 19c |
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” |
CSV | Text file in CSV format |
Comments
0 comments
Please sign in to leave a comment.