EBIFour.com Training Clarify Tips Navigating the EBI / Cleo Clarify Postgre Database
Navigating the EBI / Cleo Clarify Postgre Database
30th April 2016
Using your favorite SQL Explorer, such as DbVisualizer or SQuirreL SQL Client, you’re able to access the EBI / Cleo Clarify PostgreSQL Database. Inside the database, you’ll find helpful values that may be useful for your integration needs such as Trading Partner names, Control Numbers, and other important data stored within.
With a valid PostgreSQL JDBC driver (Click Here) and the database connection parameters, you can access those tables through postgres -> EBI -> TABLE.
Inside, you’ll find many tables that will
provide useful such as logging data from the Auditor (Log of Acknowledgement, Log
of Connection, and Log of Message)
and also behind the scenes access to EBI objects and their values. Below are tables that you may find very
useful:
- CtrlNumGen
– This table contains the fully-qualified name of the Control Number Generator
and the last number used. Use this table
to access your interchange, group, or message control numbers for your EDI
processing.
- GSSV –
This table contains the Key and Values for your Global Variables.
- NEXT_NUMBER
– This table contains the Next Number Key, Value, and Description.
- TRADING_PARTNER
– This table contains the Trading Partner ID and Values.
For FREE OF CHARGE, we will provide the database connection parameters and show you how to access these files. Please Contact Us to set-up a time to review the process and help you take your integration to the next level!
Sean Hoppe Consulting Group will be in attendance at Cleo / EXTOL University in Las Vegas. Come say hello and inquire about what we can do for you!
By: Sean Hoppe on