How to access SAP Portal 's Database in NW7.3

[Former Member]

I want to create tables, write some data to store some information in Portal Database.

How can I access SAP Portal's database and create these tables?

[robertot4s · Accepted solution]

Hi Suhaas,

You have different ways to achive this:

- Create in NWDS a component of type 'Dictionary' to create the tables, and access them using JPA (Java Persistence API).

- Use CAF (SAP Composite Application Framework).

Regards,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

Thank you.

Are there any more info/examples , that I can see how we can create custom Tables & Fields through either code or manually in the Portal Database and use them either using JPA/CAF or SQL to update the Tables on runtime?

[robertot4s · Accepted solution]

Hi,

Here you have some information:

- Providing Java Dictionary Tables and Data Types: http://help.sap.com/saphelp_nw73ehp1/helpdata/en/48/58df4dc34f58d9e10000000a421937/content.htm?frame...

- JPA: It is Java standard, so you can find a lot of information about it:

http://www.objectdb.com/java/jpa/getting/started

- Composing Services with CAF:

http://help.sap.com/saphelp_nw73EhP1/helpdata/en/49/80b066798a4ba2a1e26ce93997e839/content.htm?frame...

Maybe is easier Dictionary Components + JPA.

Regards,

Roberto

[adren_dsouza]

Hi ,

I remember doing this. I created a table using a dictionary project in NWDS . After you deploy the dictionary project, the table will be created in the portal database.

You can then create a system object of type JDBC, with appropriate query string pointing to portal database .

Access this system object in the code using IConnectorGatewayService

Regards,

Adren