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-support/software-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.
The following .dll files need to be copied to the System32/Win32 and SysWOW64 folders on the machine running Workbench in order to use the SAP CDATA connection tool: