ODBC Servers - marklogic-community/roxy GitHub Wiki

The Roxy Deployer allows you to create ODBC servers. The simplest way to do so is to uncomment the "odbc-port" property in build.properties. That will trigger Roxy to include the following snippet in ml-config.xml:

<odbc-server>
  <odbc-server-name>@ml.app-name-odbc</odbc-server-name>
  <port>@ml.odbc-port</port>
  <database name="@ml.content-db"/>
  <modules name="@ml.modules-db"/>
  <authentication>digest</authentication>
</odbc-server>

The variables will be substituted for as usual. You can also include that snippet yourself directly into ml-config.xml, but if you do so, use a property other than "odbc-port" to avoid the default behavior. You can call it anything you like. For instance, you could define this property in build.properties:

my-odbc-port-num=8123

And add this to your ml-config.xml:

<odbc-server>
  <odbc-server-name>@ml.app-name-odbc</odbc-server-name>
  <port>@ml.my-odbc-port-num</port>
  <database name="@ml.content-db"/>
  <modules name="@ml.modules-db"/>
  <authentication>digest</authentication>
</odbc-server>