0

I would like to be able to synchronise a DB2/AS400 database with a Google sheet in order to use it with a Google Appsheet.

Is there a way to do this with Appscript for example?

Cédric MEYER
  • 460
  • 1
  • 7
  • 21
  • 2
    Does the `DB2/AS400 database` offere some kind of API that allows you to fetch data with the [UrlFecthApp](https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app)? – ziganotschka Oct 01 '20 at 12:57

1 Answers1

0

Use Java and JDBC as decribed by this question and answer -- How to connect Google Sheets to Database.
Just use the JTOpen JDBC driver (https://sourceforge.net/projects/jt400/) to connect to Db2 for i.

jweberhard
  • 576
  • 3
  • 7