BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Can SAP data services connect to Azure MySQL ?


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
tsunajikun
Forum Member
Forum Member



Joined: 23 Jan 2019

Posts: 3



PostPosted: 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
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: 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
Forum Member



Joined: 23 Jan 2019

Posts: 3



PostPosted: 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
Forum Member



Joined: 23 Jan 2019

Posts: 3



PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0277 seconds using 17 queries. (SQL 0.0032 Parse 0.0008 Other 0.0237)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo