New

• Writeback page updated with Lake component UI

  The Writeback page now uses the Lake component’s UI, providing a more consistent and user-friendly experience across the platform.

Improved

• "Migrated" checkbox now works correctly in the Lake component.

• Refresh functionality fixed and now works in Audit Logs.

• Added new button animations to enhance user interaction feedback.

Bug Fixes

• Fixed ClickHouse integration bugs.

New

• Alert Notifications: Receive real-time alerts for important events and updates.

• Enhanced Error Messages: New popup dialogs provide clearer and more actionable error information.

We're excited to introduce Unihub - your centralized hub for managing your organization's Unistream platform usage, subscriptions, and administrative tasks.

Key Features

• Usage Tracking: Monitor and analyze your organization's Unistream platform usage in real-time

This guide provides step-by-step instructions for connecting DataGrip to Unistream.

Connection Steps

1. Click on Copy connection string in Unistream's Integration hub

2. In DataGrip's Database Explorer (shortcut: Alt+1 on Windows/Linux or ⌘+1 on macOS), click on the + sign

3. Select Import from Clipboard

4. Provide your password in the popup window

5. Click on Download drivers if prompted

You are now connected to Unistream's database.

Default Settings

• Socket timeout: 5 Minutes

• Connection mode: Read Only

• SQL Quotation: Double quotes (")

Video Tutorial

For a visual walkthrough, watch our tutorial video:

This guide provides step-by-step instructions for connecting DbVisualizer to Unistream.

Connection Steps

1. Download the unistream.jar file from Unistream's Integration Hub

2. Open DbVisualizer

3. Click on File → Import Settings

4. Locate and select the downloaded unistream.jar file

5. A popup window will appear showing the Unistream connection in the list

   • Click OK

6. DbVisualizer will restart automatically

7. After restart, in the Databases panel, you will see the Unistream connection

   • Double-click on the connection

8. In the connection dialog:

   • Your username (email) will be automatically detected

   • Enter your Unistream password

9. Click Connect

10. Accept driver downloads if prompted

You are now connected to Unistream's database through DbVisualizer.

Video Tutorial

For a visual walkthrough, watch our tutorial video:

New

• Added number formatting options in transformation operations.

Improved

• Enhanced column mapping validation to skip removed fields, reducing unnecessary validation errors.
• Improved UI/UX on the Minds page for better user experience and navigation.

Bug Fixes

• Fixed diagram rendering and display issues.

• Resolved visual bugs affecting subflow components.

• Fixed filter functionality in mind sources.

• Corrected various UI inconsistencies across the platform.

This guide provides step-by-step instructions for connecting TimeStored's Qstudio to Unistream.

Connection Steps

1. In Qstudio, click on Server in the top navigation panel

This guide provides step-by-step instructions for connecting DBeaver to Unistream.

Connection Steps

1. Download the JSON configuration file from Unistream Integration Hub

2. Navigate to your DBeaver workspace folder using one of these methods:

test2

Requirements

You will need a server running Ubuntu 24.04 or later with minimum specifications:

• 4 CPU cores (16 CPU cores recommended)

• 16GB RAM (64 GB RAM recommended)

• 128GB storage

• 30 Mbps internet speed

• User with passwordless sudo access (explained in detail below)

Note: The application is resource-intensive. More CPU cores (16+ cores) and especially more RAM (64GB+) are strongly recommended for optimal performance.

Setup Passwordless Sudo Access

Jenkins requires passwordless sudo access to execute deployment and system-level commands automatically, as it runs under a non-interactive service account.

1. Edit the sudoers file safely:

2. Add this line (replace "username" with your deployment user):

3. Save and exit

Jenkins Installation

1. Update Packages

2. Install Java

3. Add Jenkins Repository Key

4. Add Jenkins Repository

5. Update Packages with Jenkins Repository

6. Install Jenkins

7. Start Jenkins Service

Unistream Configuration

1. Clone Repository

Use "Unistream" as the username and the PAT token provided via email as the password

2. Navigate to Directory

3. Run Configuration Script

The script will ask for VM host, sudo user, and password. This information is used for SSH connection. For VM host, specify the IP address of the same machine in the case of single VM deployment.

4. Get Admin Password

Jenkins Configuration

1. Open {Jenkins host}:8080 in your browser

2. Enter the admin password and complete the registration

3. Go to Plugins → Available plugins

4. Find and install the "Publish Over SSH" plugin

Help

For questions, please contact the datamind team.

New

• More intuitive icons for Excel file download buttons in Warehouse

  We’ve updated the icons for Excel file downloads to be more intuitive and visually aligned with the overall UI design, improving user clarity and consistency.

• Unified table UI for WH and Lake modules

  We’ve implemented WH’s improved table design in both WH and Lake modules. This provides a consistent experience and better usability across both sections.

Improved

• Added warning messages on certain views to guide user actions and prevent common mistakes.

• Enhanced table layout responsiveness.

Bug Fixes

• Fixed validation issues for dimension tables.

• Resolved various UI misalignments and restored missing icons and buttons.

• Fixed the minimap display in the Lineage section.

• Fixed an issue where role icons were not displaying correctly in User Management.

This guide provides step-by-step instructions for connecting Google Analytics 4 to Unistream.

Prerequisites

You will need:

• A Google account with access to Google Cloud Console

This guide provides step-by-step instructions for connecting Microsoft Power BI to Unistream.

Prerequisites

You will need:

• Microsoft Power BI Desktop installed on your computer (recommended to install via Microsoft Store)

This guide walks you through setting up the integration between Unistream and Microsoft Excel.

Prerequisites

You will need:

• Microsoft Excel installed on your computer

• Clickhouse ODBC driver

• Unistream platform credentials (email and password)

Installation Steps

1. Install Clickhouse ODBC Driver

1. Download the Clickhouse ODBC driver from the official GitHub repository:

2. If Windows is preventing you from running the .msi file:

   • Unzip the zip file

   • Right-click on the .msi file → Properties

2. Connect Excel to Unistream

1. Open Microsoft Excel

2. Navigate to the Data tab in the ribbon

3. Click on Existing Connections

4. Select Browse for More

Working with Unistream Data in Excel

Loading a Complete Table or View

1. In Excel, click on Queries & Connections

2. In the right panel, right-click on the connection named "The best Data Platform"

3. Select Edit

4. This will open the Power Query Editor

Running Custom SQL Queries

1. Follow steps 1-3 above to open the Power Query Editor

2. Remove all steps except the Source step

3. Click the settings icon (gear) on the Source step

4. Replace the default query with your custom SQL

Using Pivot Tables with Unistream Data

You can create powerful data visualizations by using Pivot Tables with your Unistream connection:

1. Select your data range

2. Navigate to the Insert tab

3. Click Pivot Table

4. Choose your data source and placement

Video Tutorial

For a complete walkthrough of these features, watch our tutorial video

Troubleshooting

If you encounter connection issues:

• Verify your Unistream credentials

• Check that the Clickhouse ODBC driver is properly installed

• Ensure your network allows connections to the Unistream platform

• Contact your system administrator for assistance with firewall settings

For additional support, please contact the Unistream support team.

This document outlines the network configuration requirements for Unistream on-premise deployment, including port access requirements and domain whitelists for both Jenkins and Unistream machines.

Domain Whitelist Requirements - Quick Reference

Jenkins Server Domains

Unistream Machine Domains

Port Access After Deployment

Administrator Access (Full Access)

Administrators should have access to the following ports:

Standard User Access

Standard users should have access to the following ports:

Domain Whitelist Requirements (Detailed)

Jenkins Server Whitelist

Last updated: 05-08-2025

The Jenkins server requires access to the following domains:

Unistream Machine Whitelist

Last updated: 05-08-2025

The Unistream machine requires access to the following domains:

Operating System & Package Management

Database Systems

Development Tools & Languages

Version Control & Source Code

Container & Cloud Services

External Libraries & Assets

Unistream Services

Help

For questions, please contact the datamind team.