Creating a settings.xml database definition for Odoo for use with on-premises variants of Invantive UniversalSQL

Go to Dutch version

For use with on-premises products such as Invantive Control for Excel, Invantive Data Replicator or Invantive Query Tool you may want to define a completely configured database definition.

Using a configured database definition instead of the default ones moves the entry and maintenance of credentials and settings to a dedicated file. This simplifies large scale deployments in server farms, such as for Invantive Data Replicator. However, you can always use the default Odoo driver in the database group “Various” to log on interactively to.

Odoo settings.xml

The typical contents of a settings.xml file for Odoo are:

<?xml version="1.0" encoding="utf-8"?>
<!--

Settings.xml databases configuration file for a database with one Odoo data container.

-->
<settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  VersionUpdateDate="2023-03-07T11:30:29.5291693Z"
  version="5">
  <group
    id="c432f078-62f0-414e-b05a-38fa0a36830b"
    sortingOrder="0"
  >
    <connection
      name="Odoo"
      manual="true"
      authentication="Default"
      sortingOrder="1"
      shortDescription="Odoo.com"
      id="66e26d5c-8b04-4e2c-830d-450c428c3442">
      <database
        order="10"
        alias="odo"
        provider="Odoo"
        userLogonCodeMode="Hidden"
        passwordMode="Hidden"
        defaultUserLogonCode="john.doe@acme.com"
        defaultPassword="password-or-api-key"
        connectionString="server=myserver.acme.com;database=mydatabasename"
      />
    </connection>
  </group>
</settings>

Save this file as Unicode UTF-8 file in %USERPROFILE%\invantive\settings-odoo-sample.xml and make following changes:

  • Replace john.doe@acme.com by the Odoo log on code.
  • Replace password-or-api-key by the password for the Odoo log on code, or an API key (database specific or global).
  • Replace myserver.acme.com by the name of the Odoo server.
  • Replace mydatabasename by the name of the Odoo database (see also Where can I find my current Odoo database name in Odoo itself?).