Pete ScottinRed Pill AnalyticsJoining It All UpWhen I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is…Sep 14, 2017Sep 14, 2017
Pete ScottinRed Pill AnalyticsTunneling Through the CloudsOracle Cloud and SSH TunnelingApr 19, 2017Apr 19, 2017
Pete ScottinRed Pill AnalyticsUsing ODI with Git Versioning — Part 2: A Game of TagLast time I blogged about getting started with the new Git VCS functionality in Oracle Data Integrator (ODI) 12.2. Then, I promised to…Jan 23, 20172Jan 23, 20172
Pete ScottinRed Pill AnalyticsUsing ODI with Git Versioning — Part 1: The BasicsLast time I went through some of the basics about getting the latest patch-set of ODI to connect to a GitHub.com VCS repository. Today I…Dec 15, 2016Dec 15, 2016
Pete ScottinRed Pill AnalyticsSource, The No Longer Secret SauceWorking as an IT Professional I need to adhere to standards; working in consulting these standards may vary between customer organizations…Dec 9, 2016Dec 9, 2016
Pete ScottinRed Pill AnalyticsModules of KnowledgeOne of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to…Sep 30, 2016Sep 30, 2016
Pete ScottinRed Pill AnalyticsMind the Gap — Getting the Number on ODI SequencesAt work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about…Apr 26, 2016Apr 26, 2016
Pete ScottinRed Pill AnalyticsODI 12c LOOKUP ComponentsIn the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables)…Apr 14, 20161Apr 14, 20161
Pete ScottinRed Pill AnalyticsMaking Stuff UpMy whole data career has been about finding the truth within data, seeking correlations within and between data sources (and not always…Mar 8, 2016Mar 8, 2016
Pete ScottinRed Pill AnalyticsA Thought on ODI VariablesThis is my first contribution on Medium under the Red Pill Analytics brand. I hope I will keep up the high standards of my co-workers.Feb 18, 2016Feb 18, 2016