SAGE 300 CRE and 64-bit ODBC or DSN. Possible?

We're trying to set-up a workstation which would allow a 3rd party company (via Microsoft Runtime Integration, etc) to read data off our 300 CRE via the creation of 64-bit ODBC or DSN ... eventual goal is to get our Sage CRE database sending data to an Azure site. Thanks in advance.

Parents Reply Children
  • 0 in reply to Jay Converse Acumen

    Hi Jay,

    Is there anyway you can further explain this? We are attempting to start testing out PowerBI using our Sage300 data and currently connect to PowerBI using an ODBC connection. Our issue is that since the Sage300 driver is 32 bit and the PowerBI 'Data Gateway' app we use is 64 bit (no 32bit option) they are incompatible and therefore automatic refreshes aren't possible which is discouraging us from building reports and moving forward. We would like end users to be able to refresh data themselves without having someone with the backend knowledge going into individual reports and refreshing source files etc...

    The SQL replicator is looking like an option as well...

    Thank you,