Pre-requisites for having EM Server journal in database (odbc)

Hi,

Corresponding to this topic, could you be more specific ? I mean once the server is installed and we want to plug the journal to an external database through ODBC, what is the configuration needed on the database side : name of schema, necessary tables, columns and types. Is it possible to summarize it through an excel file or a simple picture ? I can see you say it’s the same as the internal journal but I think a documentation would be better :

Hi Romain,

You just have to create an ODBC DSN on the server and switch the journal to that DSN in Journal configuration. The server will automatically create the required tables with a fixed name or validate the structure of the existing tables in case they already exist.

Documentation can be better, I agree. We will improve it.

Ok so it means the user used must have the create/alter table privilege If I’m not mistaken. Important to mention in the documentation.