I am an ETL developer developing Altibase DB and interworking.
Altibase is a memory DB and I want to work with TOS DI 7.1 version.(http://altibase.com/)
Since there is no DBMS provided in TOS DI, connection is made with JDBC and basic CRUD is also successful.
However, when I create an Altibase meta DB (connection succeeded) and retrieve the schema, the following error occurs.
!ENTRY org.talend.platform.logging 4 0 2018-08-07 09:53:55.874 !MESSAGE 2018-08-07 09:53:55,873 ERROR org.talend.metadata.managment.model.DBConnectionFillerImpl - java.sql.SQLException: Invalid argument: Table type: <TABLE | SYSTEM TABLE | VIEW | SYSTEM VIEW | MATERIALIZED VIEW | QUEUE | SYNONYM | SEQUENCE> expected, but <EXTERNAL TABLE> !STACK 0 java.sql.SQLException: Invalid argument: Table type: <TABLE | SYSTEM TABLE | VIEW | SYSTEM VIEW | MATERIALIZED VIEW | QUEUE | SYNONYM | SEQUENCE> expected, but <EXTERNAL TABLE> at Altibase.jdbc.driver.ex.Error.throwSQLExceptionInternal(Error.java:187) at Altibase.jdbc.driver.ex.Error.throwSQLException(Error.java:181) at Altibase.jdbc.driver.AltibaseDatabaseMetaData.checkTableTypes(AltibaseDatabaseMetaData.java:789) <attach file >
I have confirmed that JDBC driver provided here (Alitabase) is good for various DBMS work tools.
I would like to know if this error should be corrected in Talend or Altibase.
Altibase supports the SQL / 92 standard.
Referring to this online document about:TalendHelpCenter: Supported systems, databases and business applications by Talend components, Altibase DB is not list in the supported DB table.
In the documentation we provide a list of databases that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) databases will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.