Home
Turium Algoreus
Turium Algoreus
  • Turium Algoreus Documentation
    • Turium Algoreus Overview
      • How to Guides
        • Axons (Pipeline) User Guide
          • Algoreus Genesis
          • Algoreus Node
          • Steps for a simple batch Axon in Algoreus
          • Configuring Axon in Algoreus
          • Deploying an Axon in Algoreus
          • Running an Axon in Algoreus
          • Viewing and downloading logs in the Genesis in Algoreus
          • Scheduling an Axon in Algoreus
          • Reusable Axons in Algoreus
          • Using Triggers in Algoreus
          • Working with multiple versions of the same node in Algoreus
          • Modifying a draft Axon in Algoreus
          • Editing a deployed Axon in Algoreus
          • Duplicating An Axon in Algoreus
          • Deleting an Axon in Algoreus
          • Deploying nodes from the Algoreus Hub
          • Using node templates in Algoreus
          • Exporting and importing Axons in Algoreus
          • Dynamic resource configuration in Algoreus
          • Working with namespaces in Algoreus
        • Soma (Transformation) User Guide
          • Algoreus Soma Overview
          • Algoreus Soma Concepts
          • Algoreus Soma UI components
          • Working with multiple datasets
          • Navigating between Soma and Algoreus Genesis
          • Editing a transformation created in the Soma
          • Soma data types
          • Working with connections in Soma
          • Parsing a CSV file
          • Strings Formatting
          • Sending records to error
          • Working with numbers in Soma
          • Working with Decimal types in Soma
          • Performing date transformations in Soma
          • Filtering records
          • Finding and replacing values in a column
          • Filling null or empty cells
          • Copying, deleting, and keeping columns
          • Renaming a column
          • Joining two columns
          • Swapping two column names
          • Extracting fields to retrieve values
          • Exploding fields
          • Masking data
          • Encoding records to store or transfer data
          • Decoding records to store or transfer data
          • Applying a Hashing algorithm to a column
          • Upgrading the Soma transformation node version
          • Viewing and downloading a schema in Soma
          • Viewing Soma Service logs
        • Cerebellum (Operations and Monitoring) User Guide
          • Logging and Monitoring
          • Metrics
          • Dashboard and Reports
          • Preferences and Runtime Arguments
          • Transaction Service Maintenance
        • Engram (Metadata) User Guide
          • System Metadata
          • Discovery and Lineage
          • Audit Logging
          • Metadata Management
          • Accessing Metadata Programmatically
          • Metadata Field-Level Lineage
        • Clone (Replication) User Guide
          • Cloning overview
          • Clone Concepts
          • Adding Transformations to a Cloning Job
          • Deleting a Cloning Job
          • Tutorial: Cloning data from Oracle Database to BigQuery
        • Algology (Visualisation) User Guide
          • Dashboards
            • Using Dashboards
            • Building Dashboards
            • Manage dashboards
            • Publishing Dashboard
            • Playlist
            • Create and manage reports
            • Share dashboards and panels
            • Access Dashboard Usage
            • Search Dashboards
          • Panel Editor
            • Configure Panel Options
            • Configure standard options
          • Visualisations
            • Alert List
            • Bar Chart
            • Bar Gauge
            • Candlestick Panel
            • Canvas
            • Dashboard List
            • Flame Graph
            • Gauge
            • Heatmap
            • Histogram
            • Logs
            • Node Graph
            • Traces Panel
            • Pie Chart
            • State Timeline
            • Stat Panel
            • Time series
            • Trend Panel
            • Text Panel
            • Table
            • GeoMap
            • Datagrid Panel
            • Status history
            • Annotations
          • Explore
            • Logs in Explore
            • Queries in Explore
            • Tracing in Explore
            • Inspector in Explore
    • Turium Algoreus Connectors
Powered by GitBook
On this page
  • Adding a Connection
  • Modifying a Connection
  • Cloning a Connection
  • Edit the connection properties.
  • Removing a Connection
  • Using a Connection

Was this helpful?

  1. Turium Algoreus Documentation
  2. Turium Algoreus Overview
  3. How to Guides
  4. Soma (Transformation) User Guide

Working with connections in Soma

PreviousSoma data typesNextParsing a CSV file

Last updated 1 year ago

Was this helpful?

A connection in Soma holds information such as user credentials and host details, crucial for establishing a connection to a data source.

When using a connection in Soma and creating an axon, Algoreus generates the axon with the relevant source node and the Soma transformation. The source node is configured with all properties present in the connection.

A connection allows you to browse and sample data in supported data sources. For instance, if an Algoreus Administrator sets up a connection to BigQuery, you can utilize this connection to locate the dataset on which you want to conduct data cleansing and quality checks.

Without a connection, you are required to manually add the source node to the axon and set it up.

Note: When establishing a connection, Soma must be able to access the source.


Adding a Connection

Note: Prior to adding a database source connection, you need to upload the JDBC driver to Algoreus. This can be done from the Hub or the Namespace Admin page.

To add a connection, execute the following steps:

  1. Go to the Soma home page and select Add Connection.

  2. From the Add a connection page, select the type of connection you wish to create.

  3. Configure the connection properties.

Note: Connection names must be unique in a namespace and can include only letters, numbers, underscores, and hyphens.

  1. It's good practice to select Test Connection to ensure the connection works.

  2. Click Create.

The connection is now displayed under the connection type and is available for all namespace users. The connection can be utilized in Soma and in the corresponding source node in the Algoreus Genesis.


Modifying a Connection

To edit connection properties, execute these steps:

  1. Click on the name of the connection you want to modify. The connections are grouped by type on the left panel.

  2. Click the three dots and select Edit. You can review and test the connection properties.

  3. Click Save.


Cloning a Connection

You may want to clone connections to share them with other team members, add them to version control, or move them from a development environment to a test or production environment.

To clone a connection, perform these steps:

  1. Click on the name of the connection you want to duplicate. Connections are grouped by type on the left panel.

  2. Click the three dots and select Duplicate. Algoreus creates a new connection using the properties of the original connection.

  3. Enter a Name for the connection.

Note: Connection names must be unique within a namespace.


Edit the connection properties.

  1. Click Test Connection and resolve any issues that arise.

  2. Click Create.

The new connection is now available for use in Soma and the corresponding source node in the Algoreus Genesis.


Removing a Connection

To delete a connection, perform these steps:

  1. Click on the name of the connection you want to delete. Connections are categorized by type on the left panel.

  2. Click the three dots and select Delete. Algoreus removes the connection, making it unavailable for use.


Using a Connection

To use a connection in Soma, follow these steps:

  1. Click on the name of the connection you want to use. Connections are organized by type on the left panel.

  2. Find the entity you wish to wrangle. Soma displays up to 1000 entities per page.

  3. Click the entity.

Note: Not all entities can be sampled. Continue browsing until you find a sampleable entity.

The entity is ready for wrangling.

After performing the necessary transformations on the data, click Create Axon and select Batch Axon.

Algoreus creates an axon, adding a batch source node and a Soma transformation.

Algoreus fills the source node properties with the properties set in the connection.


Adding a Connection
Modifying a Connection
Cloning a Connection
Edit the connection properties.
Removing a Connection
Using a Connection