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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks for all the help guys, I am getting an error that others who have used the blog have also received.

After creating the SAP system in portal, then testing the connection I get the following:

First test is sucessful:

SAP Web AS Connection

Test Details:

The test consists of the following steps:

1. Checks the validity of system ID in the system object.

2. Checks if the system can be retrieved from the PCD.

3. Check whether a SAP system is defined in the system object

4. Validate the following parameters: WAS protocol; WAS host name

5. Checks if the host name of the server can be resolved.

6. Pings the WAS ping service; works only if the service is activated on the ABAP WAS.

7. Checks HTTP/S connectivity to the defined back-end application

Results

1. The system ID is valid

2. The system was retrieved.

3. The system object represents an SAP system

4. The following parameters are valid: Web AS Protocol (http) Web AS Host Name (*******************)

5. The host name *************** was resolved successfully.

6. The Web AS ping service********** was not pinged successfully. If the ping service is not activated on the Web AS, you can try to call the ping service manually.

7. An HTTP/S connection to ************sap/bw/bex was obtained successfully.

Second test fails:

Test Connection with Connector

Test Details:

The test consists of the following steps:

1. Retrieve the default alias of the system

2. Check the connection to the backend application using the connector defined in this system object

Results

Retrieval of default alias successful

Connection failed. Make sure that Single Sign-On is configured correctly

Edited by: Gary Martins on Jun 10, 2009 8:41 PM

[Former Member · Accepted solution]

Hi,

These problem arises for problem in system connection. Check it with your Basis people.

Regards

Basheer

[Former Member · Accepted solution]

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!

[Former Member]

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

[Former Member]

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)