Hi,
Please review the Anaplan Connect documentation, it walks through setting up a simple integration with databases via JDBC connection. This must be a on-prem database that has a JDBC driver. This option does not currently support writing back to a database, but can be achieved through additional scripting. For a solution that does support bi-directional integrations, please explore our other integration options (Boomi, Informatica, Mulesoft, Snaplogic).
Regards,
Jesse
Anaplan Connect works on both Windows and any Unix-like environment (Unix, Linux, Mac).
u can use linux or windows depend on your needs
the different is windows using bat(Command line)
linux using sh(Shell Script)
CMIIW
CMIIW is correct me if im wrong
Yes, both Batch on Windows and Shell on Linux/Mac/Unix are done in command line.