MySQL DataStore - SSL certificates

[djuricz]

Hi,

In SAP DS 4.2 SP6, I am trying to create a secure connection with Google Cloud SQL (Gen 1) database (which is MySQL 5.6 hosted online).

When creating a datastore, I don't see anywhere the ability to specify SSL certificates for MySQL 6.5 to make it secure trasnfer?

ODBC as an alternative remains for this but I would rather like to make the connection using the native driver.

Thanks for help,

Zlat

[djuricz]

Currently, I am able to connect at all. I will add SSL certs later (using your approach).

For Cloud SQL, Database Server Name is IP address.

BODS is not able to connect as gives me this message. It mentions that is using ODBC call although I am not using DSN. I am a bit confused as it implies that it is always using ODBC to connect to MySQL 5.5 or 5.6.

If so, I will set up ODBC connection and use it. I though that new version supports native connection to these MySQL versions and can provide direct connection using wire protocol.

[former_member198401]

Whats your Operating System on which the Job Server is installed(Unix or Windows)

Make sure that the Port is open @ the MySQL DB Server

Try putting the IP Address of the Database Server Name instead of Fully Qualified Domain Name.

You should be able to use the Native Connection in Database Datastore as it supports DSN Less Connections

Refer Designer Guide for more details

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_designer_en.pdf

Regards

Arun Sasi

[former_member198401]

You can specify the below parameters as recommended by Dirk under the Additional connection parameters separated by ;

Below information is from DS 4.2 Reference Guide

Additional connection parameters

Possible Value: Alphanumeric characters and underscores, or blank

Enter information for any additional parameters that the data source supports (parameters that the data source's ODBC driver and database support). Use the format:<parameter1=value1; parameter2=value2>

E.g.

sslverify =1;sslkey=MySQLCertKeyName;....

Regards

Arun Sasi

[former_member187605]

Additional connection parameters?