Using MDM5.5 Java Connector with SAP Enterprise Portal 6.0


SAP MDM Interview Questions and SAP MDM Tutorials

SAP MDM Interview Questions and SAP MDM Tutorials

This example uses a portal component which opens a connection to a repository running on MDM Server,
retrieves data from the repository, and closes the connection.
There are 5 steps we will implement:

  1. Set the connector libraries in the deployment descriptor file portalapp.xml
  2. Open a connection to a repository
  3. Get the physical connection via the native interface
  4. Get data from a repository
  5. Close the connection

Step 1: configure the potalapp.xml file
The MDME Connector uses the SAP Connector Framework and MDME4J libraries as a shared library.
You need to add these libraries into portalapp.xml.

&ltapplication>
&ltapplication-config>
&ltproperty name="SharingReference"
value="com.sap.portal.pcd.glservice, com.sap.portal.ivs.connectorservice,
SAPJ2EE::library:MDME4J"/>
</application-config>
</application>

Step 2 : Open a connection to a repository (using the connector gatway service)

The useful EP6 features of system object aliases and single=sign-on user mapping are available

only by using the Connector Gatway Services approach.

// Get the Connector Gateway Service 
IConnectorGatewayService cgService = (IConnectorGatewayService)
PortalRuntime.getRuntimeResources().getService( IConnectorService.KEY);

// Create ConnectionProperties for portal user
ConnectionProperties prop =
new ConnectionProperties(request.getLocale(), request.getUser());

// Get a connection
IConnection connection =
cgService.getConnection("MDME_SYSTEM_ALIAS_NAME", prop);

Step 3: Get the physical connection via the native interface

SAP MDM Interview Questions and SAP MDM Tutorials

SAP MDM Interview Questions and SAP MDM Tutorials

Retrieve the native interface from the connection, and invoke getNative method.

// Retrieve Native inteface
INative nativeInterface = connection.retrieveNative();

// Get the CatalogData the physical connection
CatalogData catalog = (CatalogData)
nativeInterface.getNative(CatalogData.class.getName());

Step 4: Get data from a repository

All methods of the CatalogData object are available for retrieving data.

The following code uses the GetResultSet method as an example.

// Create ResultSetDefinition for products table
ResultSetDefinition rsd = new ResultSetDefinition("Products");
rsd.AddField("Name");

// Create Search for products table
Search search = new Search("Products");

// Get Data from table
A2iResultSet rs = catalog.GetResultSet(search, rsd, "Name", true, 0);

Step 5:Close the connection

connection.close();

 

SAP MDM TRAINING

SAP MDM TUTORIALS

SAP MDM INTERVIEW QUESTIONS 

sapnwtraining

SAP MDM Interview Questions and SAP MDM Tutorials

SAP MDM Interview Questions and SAP MDM Tutorials

Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter
   Send article as PDF   
This entry was posted in SAP MDM TRAINING. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *