owbeg.blogspot.com
About OWB: Prototype of OneClickETL script
http://owbeg.blogspot.com/2010/11/prototype-oneclicketl-script.html
Monday, November 8, 2010. Prototype of OneClickETL script. Script drops mappings specified in Excel file! I released prototype of script which generate set of OWB mappings based on mapping specification from MS Excel file. Before running this script you need to copy Java Excel API library (jxl.jar file) to OWB HOME owb lib ext directory. Java Excel API is an open-source project hosted on sourceforge.net, homepage of this project http:/ jexcelapi.sourceforge.net/. Variable at the begining of script).
odi-usage.blogspot.com
Практика использования Oracle Data Integrator (ODI): ODI Experts
http://odi-usage.blogspot.com/p/odi-experts.html
Практика использования Oracle Data Integrator (ODI). О работе в Oracle Data Integrator (ODI). И других захватывающих вещах из мира BI. Поиск по ODI блогам. ODI 11g Логгирование/Трассировка агента. ODI 11g Agent Logging / Tracing. Рассказ о настройках уровней логгирования агента в файле ODI-logging-config.XML. И о том, как настраивать логгирование для ODI Studio. Дата публикации: 2012-06-18, Комментариев: 3. Модуль знаний для многотабличной вставки. Multi –Table Insert KM. RKM для файлов на Jython. Интерф...
odi-usage.blogspot.com
Практика использования Oracle Data Integrator (ODI): John Goodwin
http://odi-usage.blogspot.com/p/johngoodwin.html
Практика использования Oracle Data Integrator (ODI). О работе в Oracle Data Integrator (ODI). И других захватывающих вещах из мира BI. Поиск по ODI блогам. Баг выгрузки аттрибутов Essbase в ODI 11.1.1.6 исправление. ODI 11.1.1.6 – Extracting Essbase attribute members bug fix. При попытке выгрузить иерархию аттрибутов некоторого измерения Essbase. При помощи модуля знаний " LKM Hyperion Essbase METADATA to SQL. Возникала ошибка на шаге " Begin Essbase Metadata Extract. К Microsoft Active Directory. Рассма...
odi-usage.blogspot.com
Практика использования Oracle Data Integrator (ODI): июня 2015
http://odi-usage.blogspot.com/2015_06_01_archive.html
Практика использования Oracle Data Integrator (ODI). О работе в Oracle Data Integrator (ODI). И других захватывающих вещах из мира BI. Поиск по ODI блогам. Суббота, 13 июня 2015 г. Аналитика не для пользователей. Для аналитиков компаний, в противовес обычным сотрудникам, получающим уже готовые отчеты, есть программные продукты и помимо Microsoft Excel. Заметка на Хабре - 5 инструментов в помощь аналитику. Возможно, поможет подобрать необходимый инструмент быстрее, чем за полгода. Написать об этом в блоге.
owbeg.blogspot.com
About OWB: OMB*Plus extensibility - Tk GUI in OMB*Plus
http://owbeg.blogspot.com/2010/09/ombplus-extensibility-tk-gui-in-ombplus.html
Thursday, September 23, 2010. OMB*Plus extensibility - Tk GUI in OMB*Plus. Tcl interpreter allows to write GUI application with Tk extension. And as I explored there is GUI extension for Jacl Tcl-interpreter (OMB*Plus is based on Jacl/tcljava). Name of this extension is SWANK. Last jar-file of swank compiled with lates Java compiler, so the best way to experiment - use last OWB release (OWB11g R2 which use Java 6 for execution). Copy swank.jar file to OWB HOME owb lib ext directory;. Proc procCSEL {} {.
owbeg.blogspot.com
About OWB: OneClickETL 0.3.1 release
http://owbeg.blogspot.com/2011/04/oneclicketl-031-release.html
Friday, April 1, 2011. OneClickETL 0.3.1 release. New release of OneClickETL (0.3.1) support autogeneration of staging module and processflow which contains all mappings from specification. Screenshot of source system specification worksheet. Screenshot of target warehouse specification worksheet. Of OWBLand project you can find new MDL file with demo OWB project (ONECLICKETL-0.3.1.mdl) and example of specification file (OneClickETL-0.3.1.xls). Subscribe to: Post Comments (Atom). View my complete profile.
owbeg.blogspot.com
About OWB: June 2010
http://owbeg.blogspot.com/2010_06_01_archive.html
Tuesday, June 29, 2010. Generate mapping creation tcl script. I started development of OMB*Plus program for generating mapping creation script (sometime it is better to use OMB for moving OWB objects to other environment). Current status - implemented processing for 50% of operators (see table below) and processed a limited list of operator properties (for example not processed EXTRACTION HINTS, SCHEMA, etc. properties). You can download it from map reconstruct.tcl. GROUP BY CLAUSE, HAVING CLAUSE.
owbeg.blogspot.com
About OWB: November 2010
http://owbeg.blogspot.com/2010_11_01_archive.html
Thursday, November 25, 2010. Recovering OWB mapping with map reconstruct.tcl script. There is another case for using MAP RECOSTRUCT.tcl script (except using for export/import mappings between environments). Sometime dueto OWB bug/OWB repository corruption it is impossible to open map for editing in Design Center (in my practice this happened twice as I remember). The problem usually in single operator or attribute. Thursday, November 18, 2010. MAP RECONSTRUCT script update. Added processing of error duri...
owbeg.blogspot.com
About OWB: February 2011
http://owbeg.blogspot.com/2011_02_01_archive.html
Sunday, February 20, 2011. Map reconstruct script update - better support for OWB11g R2. I released new version (0.0.3) of map reconstruct.tcl script. Now this script supports OWB11g R2 "unified" mapping datatypes. Earlier releases of this script lost detailed info for several datatypes (for example, for NUMERIC datatype precision and scale properties always was zero, or zero value for length property of VARCHAR datatype). Download new release (0.0.3). Of map reconstruct.tcl script from OWBLand.