How to Create a system for connecting to mysql 5.0 in VC

[mohan_kumar20]

Hi

I am new to SAP. I am working with SAP Netweaver 7 J2EE Version and Visual Composer. I defined systems in SAP EP but i am getting SSO error.

I need to connect to Mysql 5.0 database. I have to access that database in Visual Composer.

Please help me for creating a system and Solving the SSO error.

Any flash presentations or links or materials .. please provide me the link..

Thanks

Mohan

[Former Member · Accepted solution]

Hi Mohan,

You have to create and configure your system in the system administration tab in the portal.

Usually, it looks like the following:

System from template: JDBC System

Connector properties

Connection URL: jdbc:sap:sqlserver://<serverlocation>;DatabaseName=<database name>

Driver class name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

User management properties

User mapping type: admin, user

Set the system with an alias.

Go to user administration tab and map the user with VCRole to the configured system

(the default for MSSQL is usauly user: sa and pw: admin)

Save your changes and logon to VC with this user.

The alias name should appear in your list of systems.

Hope I helped,

Shay

[mohan_kumar20 · Accepted solution]

Hi Shay

Thank you for your reply.

But it is not MSSQL(SQL Server)... It is [MySQL 5.0|http://www.mysql.com/].

[Former Member · Accepted solution]

Hi Mohan,

I've never connected to a MySQL database from Visual Composer, but I think there must be a JDBC Driver for this database.

Have a look to this [webpage of MySQL|http://www.mysql.com/products/connector/j/].

It should work as every other JDBC Driver. If you have success it would be great if you could add an wikipage into [this section|https://wiki.sdn.sap.com/wiki/display/VC/Connectivity].

There you can also read how to setup a JDBC Connection.

Best Regards,

Marcel

[mohan_kumar20 · Accepted solution]

Hi Marcel

I have seen the JDBC driver already. I need to set those connection properties in SAP EP as shay told for MSSQL server.

I need some more detailed information about the connection properties.

Please provide me some more help.

Thanks,

Mohan

[mohan_kumar20 · Accepted solution]

Hi Salein

As You said i wrote a wiki page on mysql connectivity.

Here is the link : [Click Here|https://wiki.sdn.sap.com/wiki/x/sAA7AQ]

[former_member203343]

Hi Mohan,

You need to have the MySQL driver and then follow the instructions [here|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a09424].

Regards,

Natty

[mohan_kumar20]

Thank you for your Pdf link..

I will try my work using this document.. and then if i got any other problem while creating a connection ..i will contact you at that time..

Thanks,

Mohan