WeDid: ORACLE DATABASE & EQUELLA INTEGRATION

Challenges The client wants to sync Oracle database, which contains Active Directory records, to those in Equella so that the users will be granted access to their respective repositories. The client also requested where possible reduce the queries from Equella.   Solution: Purpose Query group members from Oracle and update groups in Equella. Applications Oracle database Equella Tool…

Read More

Oracle RightNow Tips: Retrieving Country and Province IDs

The Country and Province in the address field are entered by IDs via API. Here is how we can retrieve the Country/Province values and their IDs in RightNow interface.   Retrieving Country IDs Go to Configuration > Databases > Data Dictionary. Look for Countries in the Tables list. In the table information, click on the country_id index.     Retrieving…

Read More