Skip to Content
avatar image
Former Member

How to Connect VC to a flat / Z* table?

Hello,

VC rookie here, I don't see a connection in the 'Find Data' section that allows me to access a flat Z table. I do see a connection to connect to queries etc. How do I setup VC to easily access flat tables in the backend?

Thanks

-Gary

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 09, 2009 at 05:02 AM

    Hi Gary,

    Check the below link to connect back end systems in visual composer.

    /people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer

    Regards

    Basheer

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I contacted my basis team they said SSO is setup on the java box...any other ideas? if you check out the comments on the blog above I am not the only one with this problem, someone has to have solved it..

      Thanks for the reply!

  • avatar image
    Former Member
    Jun 09, 2009 at 01:07 AM

    Hi

    You can't actually connect directly to tables in the backend, you can however call RFC function modules or BAPI's to retrieve the data you require. (I hope I've understood your question correctly)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2009 at 04:11 AM

    Hi

    First you have to define the system on portal & then use function module or BAPI. If you are using BI system then define system based on BI XMLA, BI ODBO, BI JDBC, BI SAP Query Connector. Then you can build VC model directly on BI Cube. Similar way you can connect with SQL also.

    Regards

    Sandeep

    Add comment
    10|10000 characters needed characters exceeded