The CData driver does not include all the required files to connect to SAP. In order to get these files, you will need to download and install the SAPGUI Frontend for Windows application from SAP. This can be downloaded from: https://support.sap.com/en/my-suppor...downloads.html and follow these steps:
Types of Software > Installation and Upgrades > Access downloads > By Category > SAP Frontend Components > SAP GUI FOR WINDOWS > Select the latest version
You can test if this worked by opening Start > Run > Type odbcad32 > Press Enter > Find (or create) the DSN, Click Configure > Click the Test Connection button.