The following sections guide you through using the driver to access your data with some common third-party applications. For information on installing your driver and setting the CLASSPATH, see "Installing and setting-up the driver."

Important: When using third-party tools such as Tableau, network speeds and the amount of metadata retrieved from the service can cause timeout and out-of-memory errors. You can work around these issues in the following ways.

  1. Increase timeout settings in your third-party tool. For example, Tableau offers the following guidance for timeout errors caused by large results.

    https://kb.tableau.com/articles/issue/error-extract-timeout

    You may also need to increase the Java heap size allotted for your third-party tool. This will allow the tool to manage large metadata results sent by the service. This workaround not only avoids timeout and out-of-memory errors on initial connection, but may also avoid these errors on subsequent connections.

  2. Establish your initial connection using the DataDirect JDBC Driver Configuration Manager as described in "Testing connections and queries." In addition to specifying required properties, set the SchemaMap connection property. SchemaMap specifies the location and name of the configuration file where the map of the Dynamics 365 schema is written. Once connected, you can use the connection string generated by the Configuration Manager to connect via your third-party tool. However, it should be noted that timeout and out-of-memory errors may occur on subsequent connections, depending on the CreateMap setting.