How to connect to SqlServer with VisualComposer?

[Former Member]

Hi Gurus,

I have EP6 SP 9 with Visual Composer. I want to connect to SQLServer with Visual Composer. For this, I need to create a system in Portal for Sqlserver. I think some one might have done this work. Please let me know the procedure for this........

Regards,

Michael

[Former Member]

Hi Michael,

Yes, I have done this.

You need a system to connect the SQL Server. For that you have to create define a JDBC System in the portal. You should give Connection Properties values for Connection URL & Driver Class Name.You can specify User Management value for User Mapping as admin,user.Then create an alias for this system. Test Connection.

If everything is correct, this system will be availabale in VC so that you can get the Stored Procedures from the Sql Server.

Regards,

Shemim

[Former Member]

Hi,

You're right - you'll need to define a system in the portal in order to use it in VC.

In order to define a system in the portal:

1. Create the system (System administration)

2. Create an alias for it.

3. Create a user mapping for at least one user (user administration)

I also suggest that after you do all of these steps you test the connection to the system in the portal (right click on the system and select "Connection Tests").

After you have complete these steps, you should be able to use the system in VC (when logging in using the same user you mapped).

Hope this helped,

Lior

[Former Member]

Hi!

We have done all these steps and the sistem presents a couple of fails:

- We can make a Test Data Service during developement, but whem application is deployed, we have a 500 Internal Error.

See my post:

- We were not able to get access to some SQLServers.

Best regards,

Alvaro

[Former Member]

Hi,

Please go through the following link.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a09424">How to guide on creating a BI JDBC system in portal</a>

Make sure that you specify your sql server user in the user mapping. Also, enable the tcp service in the sql server.

Hope this helps

Shobin