To connect to Sage X3 Cloud, you can use either a DSN or an ODBC connection string. Both of these methods use the odbcConnect function.

Connect to a DSN

To connect using a DSN:

cnx <- odbcConnect("CData SageX3Cloud Sys")

Provide a Driver Connection String

To connect using an ODBC connection string:

cnx <- odbcDriverConnect(connection = "DRIVER={CData ODBC Driver for Sage X3 Cloud};URL=https://x3server/;OAuthAccessTokenUrl=https://auth-domain/oauth/token;OAuthClientId=your_client_id;OAuthClientSecret=your_client_secret;Audience=https://api-audience;XAPIKey=your_api_key;Folder=SEED;")