We have an ODBC connection configured to connect to a Synergex (DBL)
system via xfODBC drivers. The ODBC is configured as a System DSN. We
can successfully query the data via Microsoft Query Excel, Microsoft
SSIS, Microsoft Access, etc...
When connecting to the same ODBC with Data Services 3.0, we get the
attached error message.
BODI-1112346: Error: Cannot load metadata table <name=all>
ODBC data source <Domino_BMM> error message for operation <SQLTables>:<
[TOD][ODBC][GENESIS]WORM: Cannot open 'GENESIS_TABLES',No privilege to
this file or directory>.
It looks like Data Integrator requires read/write access to the system
catalog tables (GENESIS_*)
We have been advised by Synergex that the issue is caused by the
Transaction Mode used (i.e. read/write).
Could you please advise which parameter in Data Services should be
changed to use Read only Transaction Mode on the datastore?
I had a look through the DSConfig.txt configuration file as well and
could not find any suitable parameters.
Please also advice if there is a workaround