Data Services 4.2 execute job from sap hana to mysql 8 report error

[Shang]

Hi all!

I install SAP IPS + DS 4.2 and configure local repository in hana db. I downloaded mysql8 jdbc driver and copy it to:

<LINK_DIR>\ext\lib

<BIP_INSTALL_DIR>\java\lib\im\<database_type>

<BIP_INSTALL_DIR>\warfiles\webapps\DataServices\WEB-INF\lib

and I restarted the EIM process server.

I also installed mysql8 odbc dirver in designer client windows environment . But when I created a mysql datastore, there was not a mysql8 option, only mysql 5.1 to 5.6 version in the designer client. I selected the 5.1 version and mysql8 windows system DSN, this was successful. I created a batch job and extract data from sap hana to mysql8, when I run the job, the error is:

The ODBC Driver Manager library for <mysql80> data sources is not set in the <MYSQL_5_1_DRIVERMANAGER> environment variable.

Set the <MYSQL_5_1_DRIVERMANAGER> environment variable by running '$LINK_DIR/bin/DSConnectionManager.sh'.

what shall I do next?