Connect to Dynamics 365 using Node.js

You can connect to Dynamics 365 from Node.js using Devart ODBC Driver for Dynamics 365.

Install the odbc package

Run the following command to install the odbc package.

npm install odbc

Define a connection string

An ODBC connection requires a connection string, which can either use a predefined DSN or be specified through connection string parameters (a DSN-less connection).

For information about available parameters, see Connection string parameters.

DSN connection string

You can use a connection string with a predefined DSN.

const connectionString = 'DSN=your_dsn';

If you need credentials other than those used in the DSN, specify them in the connection string to override the DSN values.

const connectionString = 'DSN=your_dsn;User ID=your_username;Password=your_password';

For information on configuring a DSN on specific operating systems, see instructions for Windows, macOS, or Linux.

DSN-less connection string

You can establish a connection without a DSN by specifying all necessary parameters directly in the connection string.

The following example uses OAuth 2.0 authentication.

const connectionString = 'DRIVER=Devart ODBC Driver for Dynamics 365;Authentication=OAuth;Refresh Token=your_refresh_token';

For more information, see DSN-less connections.

Connect to Dynamics 365

The following Node.js code demonstrates how to connect to Dynamics 365 and fetch data using the ODBC driver.

const odbc = require('odbc');

// Define an async function to connect to a data source and execute a SQL query
async function connectAndQuery() {
  // Declare a variable to hold the ODBC connection
  var connection;

  try {
    // Define an ODBC connection string
    const connectionString = 'your_connection_string';

    // Create an object that represents a connection to a data source
    connection = await odbc.connect(connectionString);

    // Execute a SQL query to retrieve data from the data source
    const result = await connection.query('SELECT accountid, name FROM account');    

    // Print the query results
    console.log('Dynamics 365 data:', result);

    // You can integrate this data into your app logic here
    // Example: Save the result to your application's database or display it on the UI
  } catch (error) {
    // Handle any errors
    console.error('Error connecting to Dynamics 365 via ODBC:', error);
  } finally {
    // Ensure the connection is closed to free resources
    if (connection) {
      await connection.close();
    }
  }
}

// Call the function as part of your application's workflow
connectAndQuery();