I need to import data from an existing ERP MSSQL database into OFBiz.
So far I've only used the BSH connection to run scripts that include the
MSSQL jdbc to access the data. I'm looking for a different method than
BSH because it seems to encounter issues that I haven't been able to
resolve without a server restart which makes import script development
much more time consuming.
Does anyone know of a better environment where the MSSQL jdbc can be
used to access external data while still having access to the OFBiz
environment like BSH?
I got the idea for using BSH from this webpage which is a bit out of date:
http://www.opensourcestrategies.com/ofbiz/entities_services.php (A Word
About BeanShell section)