Skip to Content
0

Creating a connection in SAP BO 4.1 SP 5 IDT to MYSQL database via SSH Tunneling

Nov 08, 2016 at 09:03 AM

89

avatar image

Dear Experts,

We have a requirement to create a connection from SAP Business 4.1 SP5 IDT tool to MYSQL databases which is under linux via SSH tunneling. At present in IDT while creating connection it does not ask additional parameters like SSH tunneling option, but we have such a requirement that we need connect to MYSQL databse via SSH tunneling only to create reports in webi through universe.

Fore more info our SAP BO server under Linux Plotform (SAP HEC) and MYSQL database in under Amazon cloud.

Can some one help us how we can achieve this. I understand that if we open the port in MYSQL db, we can directly connect but it is security violation and it is not allowed. The only way is using SSH tunneling.

You help in this regard will be truly appreciated.

Hari

+91-9738602012

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sateesh Kumar Nov 08, 2016 at 11:36 AM
0

Hi Hari ,

afaik ,this can't be done . You'll need to connect to database itself .

Thanks

Sateesh

Share
10 |10000 characters needed characters left characters exceeded
Hari Reddy Nov 10, 2016 at 04:48 AM
0

Sateesh - Thanks for the info. If this is the case SAP should think and this option because other BI tools have this option.

Share
10 |10000 characters needed characters left characters exceeded