🔗 How to Configure VNet Peering for Azure Data Factory and Oracle Integration This guide walks you through securely connecting Azure Data Factory (ADF) to an Oracle Virtual Machine hosted in a different Virtual Network. By setting up VNet Peering and configuring a Managed Virtual Network Integration Runtime (IR), you can enable private, secure data … Read more
Additions Common Data Model New Common Data Model (CDM) views have been introduced, conforming to the latest standard: Employee Domain Customer & Supplier Domains Project Domain These views establish a consistent and scalable approach to data modelling across core business domains, streamlining downstream reporting and integration. CDM Functions Key functions have been revised to support … Read more
Additions 202409 ⚠️ Created:global_company_202409.sql ⚠️ Created:global_organisation_202409.sql⚠️ Created:customer_details_202409.sql Datamart views have been created to ensure a seamless transition for clients migrating from 202404 to 202409, providing a structured and usable view for ongoing data integration. These views have been explicitly versioned with the 202409 signature to: Common Data Standard ⚠️ Created:project_core.sql ⚠️ Created:project_codes.sql ⚠️ Created:employee_item_codes_expense.sql ⚠️ … Read more
🧾 Overview This view provides attribute-level values related to employee absence and leave entitlements, enabling structured DataMart-level analysis across both transactional absence events and annual entitlement summaries. 📚 Description The Employee Item Codes Absence view translates raw absence and entitlement data into attribute-coded rows that support dimensional modelling. Each row identifies: 🏗️ Source Tables 📦 … Read more
Purpose This view is part of the Common Data Standard, following an item and codes style table structure, ensuring consistency in data modelling across financial and operational datasets.The Employee Item Codes Expense view provides structured details on the various codes associated with employee expense items. It captures key attributes such as expense type, cost centre, … Read more
Overview The Employee Item Values Expense view provides the transactional value layer for employee expense and mileage items within the Common Data Model (CDM). It captures the key numeric measures associated with employee claims and presents them in a standardised long-form item structure, enabling flexible analysis, auditability, and controlled reuse across reporting and planning use … Read more
Project Description The PinPoint Application Tracking System Integration project aims to integrate the PinPoint recruitment platform with internal systems, specifically by: The goal is to streamline recruitment data flow, ensuring that job postings are automatically synchronised, consistently formatted, and securely integrated into internal systems. Risks & Issues Key Risks Key Issues Main Tasks & Deliverables … Read more
Project Description The Regional Project Data Integration aims to integrate legacy project data from Deltek Vision systems in the APAC, NA, and CAN regions into the Data Warehouse. This integration will enable automated business reporting before the GMIS ERP system is implemented in these regions. The main objective is to ensure that historical and active … Read more
1️⃣ Overview The Data Warehouse (DWH) enforces role-based access control (RBAC) and Multi-Factor Authentication (MFA) to secure access across: All users must authenticate using MFA when accessing database resources and storage accounts. Access Governance and Security 2️⃣ User Access and Membership Groups Volumes – Users and Type 3️⃣ SQL Server Access Control SQL Server permissions … Read more
Additions Customer Details & Project Details APC Alterations General Ledger Transaction Customer Details (CAD & USD) Business Opportunity Dates (Busopp Dates) Notes The following SQL scripts have been modified and differ from previous versions: There were additional alterations to cdm to support transaction error logging 1. ⚠️ DIFFERENT: create_table_comment.sql2. ⚠️ DIFFERENT: create_table_log.sqlSource ID altered to … Read more