To connect to SAP Ariba, 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 SAPAribaProcurement Sys")

Provide a Driver Connection String

To connect using an ODBC connection string:

cnx <- odbcDriverConnect(connection = "DRIVER={CData ODBC Driver for SAP Ariba Procurement};ANID=AN02000000280;API=PurchaseOrdersBuyerAPI-V1;APIKey=wWVLn7WTAXrIRMAzZ6VnuEj7Ekot5jnU;AuthScheme=OAuthClient;InitiateOAuth=GETANDREFRESH;OAuthClientId=testClient;OAuthClientSecret=testClientSecret;UseSandbox=false;")