ODI / Middleware - onenote lbm

Oracle documentation

https://docs.oracle.com/en/middleware/fusion-middleware/

Linkded servers for ODI

https://support.microsoft.com/en-us/help/816701/error-message-ole-db-provider-sqloledb-was-unable-to-begin-a-distribut

https://support.microsoft.com/en-us/help/839279/you-may-receive-a-7391-error-message-in-sql-server-2000-when-you-run-a

Linked server in SQL Server

https://www.simba.com/docs/ODBC_QuickstartGuide/content/quick_start/windows/connecting/linkedserver.htm

SQL Server Connection

https://sonra.io/2009/05/01/troubleshooting-odi-connectivity-to-sql-server-express-2005/

Developers Guide

https://docs.oracle.com/middleware/1212/odi/ODIDG/setup_topology.htm#ODIDG171

Caching in ODI Investigation

https://www.rittmanmead.com/blog/2015/09/obiee-bi-server-cache-management-strategies/

https://blogs.perficient.com/2018/10/03/obiee-automated-cache-purge-using-odi/

ODI overall Manual

https://docs.oracle.com/middleware/12212/odi/administer-develop/odi_console.htm#ODIAD1263

ODI architecture

https://docs.oracle.com/cd/E29542_01/integrate.1111/e12641/overview.htm#ODIGS111

Oracle Knowledge Modules

http://www.ateam-oracle.com/oracle-data-integrator-best-practices-using-loading-knowledge-modules-on-both-on-premises-and-cloud-computing/

http://www.kpipartners.com/blog/bid/151030/A-Detailed-Explanation-of-ODI-Knowledge-Modules-LKM-IKM

Performance tuning the array size and batch update size

https://sonra.io/2011/03/22/odi-jdbc-variable-binding-500-performance-gains-array-fetch-size-batch-update-size-row-prefetching-and-the-array-interface-and-an-issue-when-running-the-agent-in-weblogic/

Query Cache Parameter

https://gerardnico.com/dat/obiee/obis/query_processing/query_cache_parameterhttps://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG226

Purging the cache

https://gerardnico.com/dat/obiee/obis/query_processing/query_cache_purging

NQS Config

https://gerardnico.com/dat/obiee/obis/nqsconfig.ini

NQSConfig for BI ODBC

https://gerardnico.com/dat/obiee/obis/odbc_function

Partition Exchange in Oracle ODI

http://www.ateam-oracle.com/using-oracle-partition-exchange-with-oracle-data-integrator-odi/

https://blogs.oracle.com/warehousebuilder/odi-11g-how-to-load-using-partition-exchange

Oracle Data integtrator Console interface

https://docs.oracle.com/middleware/12212/odi/administer-develop/odi_console.htm#ODIAD1248

Google search,

how to override caching in ODI

Building solution in ODI

https://www.oracle.com/technetwork/articles/bi/radtke-giampaoli-odi-cloud-3433819.html

Customizing knowledge modules

https://www.clearpeaks.com/customizing-odi-knowledge-modules/