I was wondering if there was a way to configure the Compass JDBC Driver to work with Excel. We create a lot of end user tools in Excel with S3 and now that we're moving to Cloud Suite I was hoping there was a way to continue doing this with the data lake. A lot of our current tools include vba code to interact with the data. Even if we had to start using java for these tools that would be fine.
Thanks,
Bill
I know this has been awhile. This is Rich Bendickson from Dashboard Gear. We have written an adapter that basically sits between Infor and your Excel so you can query the data in Excel so, you can't really use Compass JDBC directly in Excel as Excel can't talk to JDBC directly, but we have a wrapper that accomplishes that.