Author |
Message |
tsunajikun Forum Member


Joined: 23 Jan 2019
Posts: 3

|
Posted: Wed Jan 23, 2019 5:06 am Post subject: Can SAP data services connect to Azure MySQL ? |
|
|
My data source work fine when I test connect to Azure MySQL.
Image link
But when I create datastore and use that data source I get error
Image link
And sometime I get error
Image link |
|
Back to top |
|
 |
Marek Chladny Forum Advocate


Joined: 27 Nov 2003
                Posts: 19320 Location: Bratislava

|
Posted: Wed Jan 23, 2019 5:18 am Post subject: Re: Can SAP data services connect to Azure MySQL ? |
|
|
[Moderator Note: Moved from General Discussion to Data Integrator -> DI: Designer and Job Design] |
|
Back to top |
|
 |
tsunajikun Forum Member


Joined: 23 Jan 2019
Posts: 3

|
Posted: Tue Jan 29, 2019 11:33 pm Post subject: Re: Can SAP data services connect to Azure MySQL ? |
|
|
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"
Image link
Guide me please how to config ssl |
|
Back to top |
|
 |
tsunajikun Forum Member


Joined: 23 Jan 2019
Posts: 3

|
Posted: Mon Jun 17, 2019 10:17 pm Post subject: Re: Can SAP data services connect to Azure MySQL ? |
|
|
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 |
|
Back to top |
|
 |
|