Is it possible to connect to a DB2/AS400 database? #31918
-
|
I'm trying to connect an AS400, is it possible to have the driver? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 6 replies
-
|
Airbyte has a connector to DB2 https://docs.airbyte.com/integrations/sources/db2 check the documentation. I don't have knowledge about what or imitations of AS400. Did you try to use the current connector or explain what is specifciation of As400? |
Beta Was this translation helpful? Give feedback.
-
|
Configuration check failed |
Beta Was this translation helpful? Give feedback.
-
|
it looks is not possible and you need an special jar to connect to this type of database. At the moment DB2 is not in the roadmap for improvements by the team. You can try to contact IBM or the service you use to get this jar and edit the current connector code. |
Beta Was this translation helpful? Give feedback.
-
|
Hi everyone, The problem is that I don't know how to replace the jdbc of db2 with this one in airbyte config/folder :/ If someone could help, it would be nice |
Beta Was this translation helpful? Give feedback.
-
|
I need the connector forIBM System I, aka IBM AS400. The jdbc driver is the one cited here:
|
Beta Was this translation helpful? Give feedback.
-
|
Hi @marcosmarxm , @andymalo43 |
Beta Was this translation helpful? Give feedback.
-
|
You need to rebuild the docker container for the connector. You can check Airbyte documentation how to do it. |
Beta Was this translation helpful? Give feedback.
-
|
Where are the instructions ? |
Beta Was this translation helpful? Give feedback.
Configuration check failed
State code: 42968; Error code: -4472; Message: [jcc][t4][10109][10354][4.28.11] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QAS databases. To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path. Connectivity to QAS databases is enabled by any of the following license files: [ db2jcc_license_cisuz.jar ]. ERRORCODE=-4472, SQLSTATE=42968