Accessing MDM Data in portal

[lokesh_kamana]

Hi all,

I am portal devloper.

and i am learning MDM now.

I have done a sample appln for accessing MDM data in portal.

Developed a portal component in NWDS.

For that i have created a system.

and by suing connector framework I.e. connector gateway service.

I am able to connect.

But now what i want to do is i want to retrieve data from a particular table(employees).

There is a field "ID"

I want to retrieve all records.

public class MDM_connection extends AbstractPortalComponent
{
    public void doContent(IPortalComponentRequest request, IPortalComponentResponse response)
    {
		IConnectorGatewayService cg = (IConnectorGatewayService)PortalRuntime.getRuntimeResources().getService(IConnectorService.KEY);
				ConnectionProperties cp = new ConnectionProperties(request.getLocale(),request.getUser());
				IConnection client = null;
				CatalogData catalog = null;
				String str = "start ";

		
				try
				{
					client = cg.getConnection("Emp_MDM",cp);
					response.write("Established the connection");
	}
				catch(Exception e)
				{
					
					response.write("This is lokesh");
					
				}
    }
}

with this code i am able to establish connection.

How to retrieve data

Thanks & regards,

Lokesh

[lokesh_kamana]

Thread is closed

[Former Member]

Hi Lokesh,

Why do you want to go for coding to establish a connection between MDM and Portal when there exist an MDM Business Package for that??

You can retrieve all the record details through standard Result Set iViews available with the BP.

Regards,

Becky.

[Former Member]

Hello Lokesh,

There is a article (link below) which has a code jow to create the records u can modify it and can access the table and the records.

The code use a record id which u can alter and then use to retrieve records.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/803e9e80-21f4-2a10-8cbf-bcf6a806...

Rgds

Ankit