Operational Data Store APIs
The following high performance APIs are built on top of the near real-time Operational Data Store (ODS) from Transact Data Hub.
ODS presents data in specific formats for operational and API use cases with:
- Real-time streams of data from Data Event Stream.
- ETL transformations from Data Engineering. (ETL stands for extract, transform and load, and is a data integration process that combines data from multiple data sources into a single, consistent data store.)
Data is pre-formatted into a relational schema, which has a similar representation to Transact itself.
Use ODS to optimize Transact enquiries, operational reporting, or the basis interfaces to other systems such as internal data warehouses.
Deploy ODS on multiple database platforms including SQL Server, Oracle, Azure SQL, Postgres, Oracle, and NuoDB.
ODS is an upgrade to the existing Relational Replication product.
Note: These APIs cannot be tested yet in our sandbox environment but are available to all customers and partners.
holdings
APIs to create, update and retrieve the various holdings of the customer and financial institution. For example, accounts, arrangements, balances and treasury/securities instrument positions.
Derivative instrument operations
API to retrieve the Derivatives trade data details of OPTION type contract
Repurchase agreements
API to retrieve the Repurchase Agreement Positions and Movements
order
APIs to create, update and retrieve various types of order instructions, such as payments, transfers and treasury/securities instrument orders.
Order Rejected Collections
API to retrieve the details of rejected collections
US Model Bank - Cash transaction
API to retrieve the details of all holds placed on an account
party
APIs to create, update and retrieve the customer and financial institution related data such as the name/address, KYC details, documents and customer contact logs
Participant List
API to retrieve information related to different participants and the users attached to those participants
product
APIs to manage the product related details such as the product catalogue, product types/groups and interest conditions
Product Interest catalog
API to retrieve the interest details for specific interest catalog
Product Interest conditions
API to retrieve all the available interest conditions
Product marketing catalogue
API to retrieve the list of products available in Marketing Catalogue
reference
APIs to manage general reference data, such as currencies, countries, IBAN structures and Swift bank codes.
Class Type Activities
API to retrieve the Class Type Activity details of an entity Id
List of legal entities defined in system
API to retrieve the legal entity details
Origination Definitions
API to retrieve the Origination Application definition details
Product internal category codes
API to retrieve the list of internal Product category codes
Questionnaire Types
API to retrieve the needs questionnaire type definition details .
Security Delivery Instruction
API to retrieve the Security Delivery Instructions
US model bank - beneficiary roles
API to retrieve the list of Beneficiary Role type definitions and the information that is mandatory for the role definition
US model bank - customer risk rating
API to retrieve the available list of customer risk rating available for a US customer
US model bank - FDIC subclassification codes
API to retrieve the deposit sub-classification codes provied by FDIC
US model bank - hold types
API to retrieve the available hold types in the system
US model bank - loan covenants
API to retrieve the available list of convenant's that can be associated with a loan based on the terms agreed for the loan
US model bank - US industry classifications
API to retrieve US industry classification or NAICS codes