My data source work fine when I test connect to Azure MySQL.
But when I create datastore and use that data source I get error
And sometime I get error
tsunajikun (BOB member since 2019-01-23)
[Moderator Note: Moved from General Discussion to Data Integrator -> DI: Designer and Job Design]
Marek Chladny 
(BOB member since 2003-11-27)
More information
I use SAP data services version 4.0
I trying to use MySQL ODBC 5.1 connect to Azure MySQL
but when I click test the system alert require ssl
Alert message:
“Connection Failed: [HY000] [MySQL] [ODBC 5.1 Driver]SSL connection is
required. Please specify SSL options and retry”
Guide me please how to config ssl
tsunajikun (BOB member since 2019-01-23)
The problem has been solved
by change password user account Azure Mysql Database
because password is too long and length SAP data services password field not enough
tsunajikun (BOB member since 2019-01-23)