I wanted to export all data from all the tables from SAP Business One to excel on the basis of schedule. Means wanted to automatically refresh my exported data into excel. I also wanted to know that is there any ODBC driver for SAP Business One as i have one option to export all the data to excel through PENTAHO or some other ETL tool, so that i will schedule all the export.
Please help me on this as this is URGENT & i am new to this.
Thanks in advance