Skip to Content
1
Apr 23, 2020 at 05:06 PM

SAP PI / PO : JDBC look up for Oracle database.

301 Views Last edit Apr 24, 2020 at 06:49 AM 2 rev

I am using SAP PO 7.5 . I need to use JDBC look up for Oracle database. I am not getting option to specify schema name. Hence I am not able to fetch table details that I need to use in mapping. Would you please help me here.

This is the connection string I am using in my adapter.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.208.156.45)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=HAYONEQA)))

I can see following list of tables.

AUDIT_ACTIONS DUAL NTV2_XML_DATA OGIS_GEOMETRY_COLUMNS OGIS_SPATIAL_REFERENCE_SYSTEMS OL$ OL$HINTS OL$NODES SAM_SPARSITY_ADVICE SDO_COORD_AXES SDO_COORD_AXIS_NAMES SDO_COORD_OP_METHODS SDO_COORD_OP_PARAM_USE SDO_COORD_OP_PARAM_VALS SDO_COORD_OP_PARAMS SDO_COORD_OP_PATHS SDO_COORD_OPS SDO_COORD_REF_SYS SDO_COORD_SYS SDO_DATUMS SDO_DATUMS_OLD_SNAPSHOT SDO_ELLIPSOIDS SDO_ELLIPSOIDS_OLD_SNAPSHOT SDO_INDEX_HISTOGRAM_TABLE SDO_PREFERRED_OPS_SYSTEM SDO_PREFERRED_OPS_USER SDO_PRIME_MERIDIANS SDO_PROJECTIONS_OLD_SNAPSHOT SDO_SRIDS_BY_URN SDO_SRIDS_BY_URN_PATTERN SDO_ST_TOLERANCE SDO_TOPO_DATA$ SDO_TXN_IDX_EXP_UPD_RGN SDO_TXN_JOURNAL SDO_UNITS_OF_MEASURE SDO_XML_SCHEMAS STMT_AUDIT_OPTION_MAP SYSTEM_PRIVILEGE_MAP TABLE_PRIVILEGE_MAP USER_PRIVILEGE_MAP XS$VALIDATION_TABLE