> > > EBI Postgre Database – TRADING_PARTNER Table

EBI Postgre Database – TRADING_PARTNER Table

7th May 2016

Sean Hoppe Consulting Group

In previous EBI 4 tips, we talked about how you can access the EBI / Cleo Clarify Postgre Database and took you on a guided tour in navigating the EBI / Cleo Clarify Postgre Database.

When you open the internal database through any SQL explorer, such as DBVisualizer or SQuirreL Client, you can find many helpful tables that can be used as reference and allow you to easily and quickly access essential data.  One of those tables is the TRADING_PARTNER table, inside of the Postgre database.  When your Trading Partner object is deployed and installed to the desired server, you can view those installed objects inside of the internal table, as shown below..

TRADING_PARTNER Cleo Clarify table

This simplistic table consists of two columns.  The first, contains the TRADING_PARTNER_ID, which lists the fully-qualified resource name which includes the EBI Project, Package, and name of the Trading Partner object in EBI.

The second column, DISPLAY_NAME, contains the value populated inside of the Trading Partner object.  Depending upon naming convention, this may also include the TP suffix if it is included in your description.  In our example, our EBI Project’s Trading Partner object for Ames contains the description of AmesTP, which is displayed in our table.  However, our Sears Trading Partner object only contains Sears in the description.  See the image below of the Trading Partner object’s descriptions, and how they relate to the values in the table.

Trading Partner comparison

Having this list can help you quickly gather the name of your trading partners that have been deployed. However, be aware that even if the Project is uninstalled from your server environment, the object may still appear in the table.  For example, the demo11 Project’s resources from EXTOL have been uninstalled, but are still shown in this table.


By: on