Datricks Connect Architecture and Requirements

Created by Roy Rozenblum, Modified on Thu, 7 Nov, 2024 at 1:08 PM by Roy Rozenblum

Purpose and Scope

The purpose of this document is to provide the IT team with the necessary specifications for creating a server that will run Datricks Connect, a tool that securely queries data from Oracle databases and transfers it to Datricks Cloud for data analysis.

Architecture

Datricks Connect is designed to run scheduled queries against Oracle databases. These schedules can be customized based on organizational needs, typically set to occur at regular intervals, typically daily. It will then upload the data to Datricks Cloud using HTTPS.

A screenshot of a video game

Description automatically generated

Server Specifications

Operating system	Ubuntu server 22.01 LTS
Memory	8Gb
CPU	4 cores
Disk volume	40 Gb

Firewall Configuration

The following firewall configurations are required for Datricks Connect to securely communicate with both the Datricks Cloud and the Oracle database.

protocol

src

dst

port

direction

purpose

TCP (https)

Datricks Connect IP address

customer-tenant-fqdn

443

outbound

Allows the agent to communicate with Datricks Cloud over HTTPS

As an alternative to opening a direct HTTPS connection, a HTTPS proxy can be used as well.

TCP (odbc)

Datricks Connect IP address

Oracle IP address

1521

inbound

Allows the agent to communicate with Oracle over the specified port.

Support

To ensure we can provide full support for the Datricks Connect server, the Datricks team requires remote access for server management. Typically, the organization grants access to the Datricks team via two user accounts, provided through a VPN and a remote desktop solution, such as Citrix, Microsoft Remote Desktop Services (RDS), or Azure Virtual Desktop (AVD).

Remote desktop instances must support installing an SSH client, such as MobaXterm or PuTTY (restricted to the Datricks user profile). SSH access to the Datricks Connect server is required to enable effective support and troubleshooting.

Conclusion

This requirements document outlines the server specifications and firewall configurations necessary to support Datricks Connect. Once the server and firewall are configured, please confirm the setup with the Datricks support team to ensure all requirements have been met.