VC over a mysql database - Anbody done it?

[Former Member]

Hi there,

I wish to create 2 JDBC connections to allow me to use SQL server over Microsoft SQL 2000 and mysql

I have successfully created the microsoft connection for BI_JDBC and the Portal JDBC (Factory Class)

However I am having difficulties creating a successful connection to the mysql database.

If I checked the wiki and it refered me to a JDBC driver search. I did not find a MYSQL compatible driver at all.

I have taken my chances with http://dev.mysql.com/downloads/connector/j/3.0.html

and tried versions 3, 3.1 and 5.0 to no avail. I have mapped using an administrator password.

Searching SDN I cannot see reference to anyone successful creating a mysql connection and all the SAP examples are MS, Oracle DB2 or MaxDB

Am I flogging a dead horse or is it possible? EP7.0 nw2004s SP10

Thanks

Andrew

[Former Member · Accepted solution]

Hi Andrew,

maybe this helps:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup?focusedCommentId=14341#comment-14341">https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup?focusedCommentId=14341#comment-14341</a>

MaxDB based on MySQL as I know.

Best Regards,

marcel

[Former Member]

Have done,

Can't give a step by step as I tried numerous things and am not 100% sure which bit did it.

As well as the instructions in the document "How To Configure a BI JDBC System in Visual Composer.pdf"

I also attempted to deploy it via an SDA " How to deploy a jdbc and jms adapter" (even though it was an XI guide it seemed relevant)

I also followed the VC wiki step by step example for MaxDB but used the MySQL files.

A reboot seemed to help more than just stop/starting the applications.

Andrew

[Former Member]

Following your comments that it is possible and that the other notes I saw were herrings I started again from scratch and it was succesful.

I used version 3.1 Driver in the end.

Thanks for your help.

[Former Member]

Hi Andrew,

can you tell us how it worked and what driver you used? This way we (or better: you) can put it in the WIKI under: https://wiki.sdn.sap.com/wiki/display/VC/JDBCConnectionSetup

for others who face that problem.

Thank you

Mario

[Former Member]

Mario,

Please see Thread

/thread/41500 [original link is broken] (in context to the Portal)

Mentioned again in:

(in context to XI)

As I said before I am Ok with MS SQL and I have done others before, mySQL seems to be eluding me.

I assume by your comment you think is possible. Any Drivers you Can Recommend?

Thanks

Andrew

[Former Member]

I'd say "transaction layer" is wrong. You don't need that at this stage. My understanding of a transaction layer is the basis ontop of it. But for a simple JDBC-connection there shouldn't be any problem. Otherwise you couldn't use mySQL for anything.

So I would ask you to investigate further in the setup. I think you simply haven't configured it properly...

[Former Member]

What actually are the error messages that you get?

Did you try to connect from the Visual Administrator?

[Former Member]

Thanks Marcel.

I thought about MaxDB and followed the VC Wiki Step by Step Guide, but it did not work.

Searching through SDN I saw a comment by an SAP contributor stating since Oracle bought the transaction layer it won't work with mySQL.

However I have seen other references where users have got it working at least in development. Cannot find any reference to mySQL and VC.

[Former Member]

What does it mean "since Oracle bought the transaction layer, it won't work with mySQL"? Oracle has nothing to do with it.

As far as I understand you, you try to setup a direct JDBC connection to the mySQL database. What you have is a "simple" driver, configuration or authorization problem.

[Former Member]

Hi Andrew,

check out this <a href="http://developers.sun.com/product/jdbc/drivers">site</a>, maybe you find a suitable driver there? The SAP Press and Helpfiles say, that connecting to a microsoft SQL Database is possible.

In our portal I found a MSsql jdbc driver installed, with sucessful connection test to northwind-database. Unfortunately, I cannot find out what driver we used.

If you still don't find a driver, I will ask my colleague if he remembers.

Best Regards, Benni

Message was edited: Sorry, I meant MSsql, not mysql. We have a MSSQL-JDBC-System defined, with working connection.