How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules

 How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules

Regardless of the version of ODI 12c used, component-style (built-in) KMs can be refreshed by executing the following SDK command from the ODI Studio Groovy editor:

OdiAdapter.getInstance(odiInstance).refreshRepositorySeededObjects (odiInstance, true);

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query.

select SCEN_NAME,TASK_NAME3,DEF_TXT from snp_scen_task snp_scen_task,

snp_scen

where

snp_scen_task.SCEN_NO=snp_scen.SCEN_NO

AND DEF_TXT like '%OdiSendMail%';

Run the below SQL query to get the load plan name and load plan step name with the corresponding scenario name.

SELECT SNP_LOAD_PLAN.LOAD_PLAN_NAME,SNP_LP_STEP.LP_STEP_NAME,SCEN_NAME

FROM SNP_LP_STEP,SNP_LOAD_PLAN

WHERE SNP_LOAD_PLAN.I_LOAD_PLAN=SNP_LP_STEP.I_LOAD_PLAN

AND SCEN_NAME IN (SELECT SCEN_NAME--,TASK_NAME3,DEF_TXT

FROM SNP_SCEN_TASK SNP_SCEN_TASK,SNP_SCEN

WHERE 1=1

AND SNP_SCEN_TASK.SCEN_NO=SNP_SCEN.SCEN_NO

AND DEF_TXT LIKE '%OdiSendMail%');

Installing Oracle Data Gateway on Windows

Download data gateway software from the below location.

https://www.oracle.com/middleware/technologies/oac-downloads.html

Extract the downloaded file as below

Open the extracted folder and double click on the datagateway.exe file

It will open the analytics gateway configuration wizard

How to check whether port is open or not in Linux

Syntax:

echo > /dev/tcp/[host]/[port] && echo "Port is open"
echo > /dev/udp/[host]/[port] && echo "Port is open"

Example:

echo > /dev/tcp/172.16.11.45/7091 && echo "Port is open"

 echo > /dev/tcp/172.16.11.45/7091 && echo "Port is open"