Skip to Content
avatar image
Former Member

How to connect to SqlServer with VisualComposer?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 15, 2005 at 06:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2007 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded