Skip to Content
avatar image
Former Member

Problem accessing MS SQL database through Visual Composer

Platform: SAP EP 7.0

Hello,

I was able to create a system connection from the portal to an external MS SQL external datasource (not part of the SAP landscape) and it tested fine. However when I try to look for stored procedures and tables with that datasource in Visual Composer, there is nothing to looking for. Could anyone tell me what am I missing from the configuration?

Thank you,

Duy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2008 at 08:38 PM

    Hi Duy,

    did you check our great [WIKI|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/cannotseetables&]?

    There are several of hints and examples.

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      don't use the SQLServerDriver from the portal in BI JDBC, there is license problem. instead download the sql driver from MS site. the url and driver is the same as regular JDBC.

  • avatar image
    Former Member
    Jan 07, 2008 at 08:31 PM

    Hi Duy,

    Just some thoughts:

    what about permissions? Does the user you are using in the VC have the proper permissions?

    Was the system check from the portal successful? Is the installation also with MS SQL database? Does it work with the database which is also used by the J2EE Engine?

    Regards,

    Holger.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, thanks for the quick response. The system connection tested fine and I mapped the user name with a read only account for that database. The database that I am trying to connect is on a Window 2003 server and there are no J2EE engine running on it. However our SAP landscape is using MS SQL for our database. When you mention permission, are you referring to what I meant by the read only account that I used to do the mapping or is there something else in portal that I need to be assigned to?

  • avatar image
    Former Member
    Jan 24, 2008 at 04:38 PM

    We have decided to use stored procedures to get access to the back end SQL database using the original MS SQL driver. Thank you for all of your help.

    Add comment
    10|10000 characters needed characters exceeded