# Data Integrations

**Real-Time Data Access**: Access the latest datasets through the platform’s data-sharing capabilities, eliminating the need for data duplication.

**Comprehensive Data Models**: Leverage structured data schemas for Monitoring, Equity, and Credit Valuations to enable consistent, streamlined data connectivity.

**Flexible Integration Options**: Connect seamlessly using Snowflake, SQL, SFTP, or APIs, with integration options tailored to your data-sharing requirements.

![Extract Agent V2](https://cdn.sanity.io/images/0lkfsbau/production/ba80b5b8630c75fc103c21c5940db1daf3271061-3600x3816.png?q=80&fit=max&auto=format&w=3840)

![Extract Agent](https://cdn.sanity.io/images/0lkfsbau/production/ccbb32d6146ceaef80d6ccaffafb93c22fd22d8e-32x32.svg)How Data Flows Through the 73 Strings Platform

## Data Integration, the 73 Strings Way

The data flow diagram illustrates the 73 Strings platform architecture, showing how upstream data flows through the integration layer and ETL pipelines into the Monitoring, Equity, and Credit Valuation modules.

The processed data is then stored in the Data Mart and distributed to downstream systems, including client data warehouses.

![Data Integrations](https://cdn.sanity.io/images/0lkfsbau/production/1294246a42e50b030afc9a38455a44b79f468681-2520x2520.png?q=80&fit=max&auto=format&w=3840)

## Your Data. Everywhere. Always.

We offer a range of integration options for seamless data ingestion and export. Over the years, we’ve identified the solutions most preferred by our clients and highlighted them below. Where needed, 73 Strings also develops bespoke integration workflows tailored to specific client requirements.

-   ![Snowflake](https://cdn.sanity.io/images/0lkfsbau/production/8ed13f59e1b73ffd705fa01524393fc06c3843b5-32x32.svg)
    
    ### Snowflake
    
    Keep your data secure, accurate, and up to date with seamless Snowflake integration. Benefit from a streamlined setup, minimal IT overhead, and effortless data connectivity.
    
-   ![High Performance APIs](https://cdn.sanity.io/images/0lkfsbau/production/9393da3f86be1b61625e4e11597131d31177a2ef-32x32.svg)
    
    ### High Performance APIs
    
    Choose from our extensive API library to seamlessly transfer data into and out of the platform. With flexible, high-performance APIs, you can select the integrations that best suit your needs.
    
-   ![SQL Database](https://cdn.sanity.io/images/0lkfsbau/production/a2da53c71c30e34da5dadd2482bf6928244a6aff-32x32.svg)
    
    ### SQL Database
    
    Leverage Azure Data Share to securely share data snapshots from Azure SQL Database and Azure Synapse Analytics across Azure subscriptions, enabling efficient and controlled data exchange.
    
-   ![Secure SFTP Share](https://cdn.sanity.io/images/0lkfsbau/production/edc75500442f6c6fab3cb547e0cee10e9a0388cc-32x32.svg)
    
    ### Secure SFTP Share
    
    Exchange and access data securely through our SFTP Data Share solution. Maintain data integrity, support compliance requirements, and simplify data transfers through a reliable and secure channel.
    

## Inbound Integrations

Inbound integrations enable data to flow directly from your client systems into the 73 Strings platform. This ensures that your client systems remain the single source of truth, while keeping the corresponding data on 73 Strings automatically synchronised and up to date. We've curated a selection of the most popular datasets to help you get up and running quickly.

-   [Issuer Details](#issuer-details)
-   [Foreign Exchange Rates](#foreign-exchange-rates)
-   [Investment & Cash Flow Data](#investment-cash-flow-data)
-   [Valuation Assumptions](#valuation-assumptions)
-   [Credit Instrument & Security Details](#credit-instrument-security-details)
-   [Data Processing & Synchronisation](#data-processing-synchronisation)
-   [Data Extraction & Synchronisation](#data-extraction-synchronisation)
-   [Portfolio Company & Financial Data](#portfolio-company-financial-data)
-   [Valuation Results & Supporting Data](#valuation-results-supporting-data)
-   [Credit Valuation Results & Supporting Data](#credit-valuation-results-supporting-data)

Issuer Details

## Issuer Details/ Portfolio Companies

Issuer details are typically sourced from the client’s CRM or company master and contain the key company-level metadata required to set up and identify an asset on the 73 Strings platform.

This data is generally non-time-series in nature and maintained at the deal level. As a result, it remains relatively static and is updated primarily when specific events or changes occur.

Issuer data can be classified into two categories:

-   **Standard Static Data:** Predefined data fields commonly used across issuers.
-   **Custom Data:** Client-specific data fields used to capture additional information beyond the standard dataset.

[Download Data Model](/tbc/)

![Issuer Information](https://cdn.sanity.io/images/0lkfsbau/production/514636a5c168378397be13d95585af95835bb74b-2520x2656.png?q=80&fit=max&auto=format&w=3840)

Foreign Exchange Rates

## FX Rates

The FX Rates integration enables foreign exchange rate data to be transmitted directly to the 73 Strings platform, automatically replacing the existing FX rates available on the platform.

You can configure the scope of the FX data by assigning it to a specific module, such as Monitoring, Equity Valuation or Credit Valuation, or choose All Modules to make the rates available across the entire platform.

This ensures that the relevant modules use the latest FX rates supplied by the client as the source of truth.

[Download Data Model](/tbc/)

![FX Rates](https://cdn.sanity.io/images/0lkfsbau/production/6b2742d636c462830584846704f1695adca745bb-2520x2250.png?q=80&fit=max&auto=format&w=3840)

Investment & Cash Flow Data

## Transactions

The Transactions integration enables the seamless transfer of investment and cash flow data from client systems to the 73 Strings platform. This data supports the calculation of key investment performance metrics, including IRR (Internal Rate of Return) and MOIC (Multiple on Invested Capital), for assets configured in the Equity Valuation module.

The integration captures all relevant transaction types, including initial investments, follow-on investments, dividends, partial exits and realised proceeds.

You can also include your internal transaction ID with each record, ensuring end-to-end traceability and easy reconciliation of transactions between your systems and the 73 Strings platform.

[Download Data Model](/tbc/)

![Transactions](https://cdn.sanity.io/images/0lkfsbau/production/a37df2259cb37a6dbc678bc212c38a0fef646436-2520x2520.png?q=80&fit=max&auto=format&w=3840)

Valuation Assumptions

## Discount Rates

The Discount Rates integration enables the transfer of key discount rate assumptions to the 73 Strings platform, supporting Discounted Cash Flow (DCF) valuations within the Equity Valuation module.

Discount rates can be configured at a country level and can include the following components:

-   **Risk-Free Rate**
-   **Equity Risk Premium**
-   **Country Risk Premium**
-   **Cost of Debt**

You can also define the applicable validity period for each rate by specifying its start and end dates. This ensures that the appropriate discount rate assumptions are applied based on the relevant country and valuation period.

[Download Data Model](/tbc/)

![Discount Rates](https://cdn.sanity.io/images/0lkfsbau/production/51b65db7b9410be1bc464039d22f4ddb7cf48f36-2520x2776.png?q=80&fit=max&auto=format&w=3840)

Credit Instrument & Security Details

## Credit Security Master

The Credit Security Master integration enables the seamless transfer of credit security structures from client systems to the 73 Strings platform, specifically supporting the Credit Valuation module. This allows clients to maintain their existing systems as the single source of truth for security-level information, while automatically synchronising the same data with 73 Strings.

The integration captures key security-level attributes required for credit valuation, including committed capital, Original Issue Discount (OID), interest terms and specifications, principal amortisation schedules, call provisions, warrants and other relevant security details.

This ensures that credit security structures are consistently maintained across client systems and the 73 Strings platform.

[Download Data Model](/tbc/)

![Credit Seurity Master](https://cdn.sanity.io/images/0lkfsbau/production/921f7b5010fa5b9656fbe61768c1345acfdba634-2520x2520.png?q=80&fit=max&auto=format&w=3840)

Data Processing & Synchronisation

## Inbound Workflow

Once an integration is executed, the 73 Strings platform performs an initial full load of all incoming data.

For subsequent runs, the system identifies newly created or updated records using metadata columns, processing only relevant changes. This ensures efficient synchronisation without reprocessing historical data.

**Meta Columns**:

Four standard metadata columns are used to track records and identify new or updated data:

-   Created On
-   Created By
-   Last Updated On
-   Last Updated By

These fields are included in all integration templates. If provided by the source system, the original values are retained. Otherwise, the 73 Strings ETL process automatically populates them based on the data source and processing timestamp.

[Download Data Model](/tbc/)

![Inbound Workflow](https://cdn.sanity.io/images/0lkfsbau/production/0bdc8496044850de17737c0a9a7cb83dfeae82e0-2520x3280.png?q=80&fit=max&auto=format&w=3840)

Data Extraction & Synchronisation

## Outbound Integrations

Outbound integrations enable data to flow from the 73 Strings platform to client data warehouses through predefined data models covering Monitoring, Equity Valuation and Credit Valuation.

Each model includes master data for funds, companies and securities, linked through common IDs to enable consistent data consolidation and consumption.

Clients can access data through these predefined models or create customised views to suit their specific reporting and analytics requirements.

**Explore our predefined data models to learn more.**

-   73 Extract and 73 Monitor
-   73 Value Equity
-   73 Value Credit

[Download Data Model](/tbc/)

![Outbound Integrations](https://cdn.sanity.io/images/0lkfsbau/production/70a9cea84c2ec81e03b634d72b1bfc48fd8e67b5-2520x2866.png?q=80&fit=max&auto=format&w=3840)

Portfolio Company & Financial Data

## Monitoring Data Model

The Monitoring Data Model provides a consolidated view of portfolio company information and financial performance data captured on the 73 Strings platform.

**Deals Data**

Includes key metadata for each portfolio company/issuer, such as business description, industry, geography and any custom data fields created by users on the platform.

**Financial Data**

Includes all financial data captured on the platform, along with the associated metadata required for interpretation, including version, reporting date, as-of date, units and currency.

[Download Data Model](/tbc/)

![Monitoring Data Model](https://cdn.sanity.io/images/0lkfsbau/production/d94d5f8cdcf1cd204c942cea81634f71df8f3489-2520x2520.png?q=80&fit=max&auto=format&w=3840)

Valuation Results & Supporting Data

## Equity Valuation Data Model

The Equity Valuation Data Model provides a consolidated view of valuation outputs and supporting data, including comparable companies and transactions, valuation metrics, cap tables, DCF discount rates, listed company details and methodology weights.

**Valuation Summary**: Summarises valuations for each company, including the methods used, assigned weights and resulting Fair Market Value (FMV).

**Cap Table**: Includes the asset's capitalisation table as maintained on the 73 Strings platform.

**Valuation Results**: Captures detailed outputs and supporting market and financial data across the different valuation methodologies applied.

[Download Data Model](/tbc/)

![Equity Valuation Data Model](https://cdn.sanity.io/images/0lkfsbau/production/1e3cc67a79725c14c90330462f7c3de59db306e2-2520x2730.png?q=80&fit=max&auto=format&w=3840)

Credit Valuation Results & Supporting Data

## Credit Valuation Data Model

The Credit Valuation Data Model provides a consolidated view of credit valuation outputs and supporting data, including discount rates and calibration, leverage and coverage ratios, security structures and warrant valuations.

**Security Structure**: Includes key details for all securities configured on the platform, such as origination date, committed principal, Original Issue Discount (OID), interest terms, drawdowns, repayments, warrants and amortisation schedules.

**Valuation Summary**: Summarises valuations across all securities and valuation dates, including the methodologies applied, assigned weights and resulting valuations.

**Discount Rate & Calibration**: Provides details of the discount rate calibration for each security and valuation date, including reference index movements and credit spreads used to reflect changes in credit quality.

[Download Data Model](/tbc/)

![Credit Valuation Data Model](https://cdn.sanity.io/images/0lkfsbau/production/5f64c22bf729d50b36773a172b86e4d81a238bf0-2520x2946.png?q=80&fit=max&auto=format&w=3840)