Scribd
Upload
23 views6 pages

Database Connectivity Inventory Guide

This document provides information for connecting databases across different business units and systems. It includes details like the priority database name, description, which systems it sources from and feeds to, network connectivity details, database admin contacts, and login credentials for the Vertica and other databases. The Vertica database listed stores customer and transactional data from all business units used for analytics and business purposes. It sources from various data warehouses and systems and feeds data to platforms like C4C and Braze.

Uploaded by

chandaatanwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
23 views6 pages

Database Connectivity Inventory Guide

This document provides information for connecting databases across different business units and systems. It includes details like the priority database name, description, which systems it sources from and feeds to, network connectivity details, database admin contacts, and login credentials for the Vertica and other databases. The Vertica database listed stores customer and transactional data from all business units used for analytics and business purposes. It sources from various data warehouses and systems and feeds data to platforms like C4C and Braze.

Uploaded by

chandaatanwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Holding / OPCO / BU / Country System Inventory Su

Priorty databases list for connecting to OPCO


DG Tools
(Business Name)
#

Example Vertica AA
Holding / OPCO / BU / Country System Inventory Submissions Networ
Description of the prioroty database Which system is this priority database Which database is this Actual Source Name.
SOURCING information from? priority system FEEDING
information to?

Database which stores customer


and transactional data from
across all BUs in MAF, used by Retail DWH, Properties DWH, LEC
various teams for analytical Central DB, Ventures DWH, C4C,
purposes and to conduct business Google Analytics, MPASS,
critical use cases. Qualtrics C4C, Braze Vertica
Network Connectivity details for raising Firewall Access (SNOW = Technical Catalog > Security > Firewall Access List)
Source on Cloud? Source IP Test/Production Business Owner IT Owner (SPOC)
YES/NO Person responsible for this Person responsible for this
system from business system from IT/Technical
perspective perspective

[Link]
(private subnet -
Yes [Link]/20) Production Prajith Nayar Prajith Nayar
> Firewall Access List)
Network Team SPOC Connection Property Database Admin SPOC: Database Name
Contact person from Network team, Contact person from This is the name
should be manager who can ensure Database team who will of the database.
the work required to open the create username and
password to access relevant
connectivity gets done data in the database

Read ONLY access to


database. User creation at
source database server to
Viswanathan Kalliyappan Radha allow EDC to read data Pradeep Sekar CA_DEV

Read ONLY access to


database. User creation at
source database server to
allow EDC to read data
Database Connectivity in Tool
Type of Database (eg. Host Port Username
SQL Server, Oracle)
(Network port number (User name for the database
used to connect to the login. Database admin spoc to
database server) provide/confirm to the
requestor.

Username
Vertica [Link] 5433 DO NOT POPULATE HERE

Username

DO NOT POPULATE HERE


Password Service Name(if applicable)

(Password for the database login. Service name or System ID


Database admin spoc to provide/confirm (SID) that uniquely identifies
to the requestor. the Database. Specify the SID
e.g. SID:<ORACLE_SID>

Password

DO NOT POPULATE HERE

Password

DO NOT POPULATE HERE

You might also like