Connect Oracle Database to Federal Reserve Market Data

Both apps 25Oracle Database 12Federal Reserve Market Data 13

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Find agency MBS operations

  Finds agency mortgage-backed securities (AMBS) operation results from the New York Fed, filtered by operation type, date range, security method, CUSIP or security description.

• Action
  Find FX swap operations

  Returns Federal Reserve central bank liquidity swap operations matching a date range and optional counterparties.

• Action
  Find reference rates by date range

  Returns the New York Fed's secured and unsecured reference rates (SOFR, EFFR, OBFR, TGCR, BGCR) or volumes published between two dates.

• Action
  Find securities lending operations

  Searches Federal Reserve securities lending operation results and extensions by date range, CUSIP or security description.

• Action
  Find Treasury securities operations

  Searches the New York Fed's Treasury securities purchase and sale operations by date range, security type, CUSIP or description.

• Action
  Get agency holdings by as of date

  Returns the Federal Reserve's SOMA agency securities holdings (agency debt, MBS and CMBS) as of a given weekly date.

• Action
  Get primary dealer market share

  Returns the latest primary dealer market share statistics, either for the most recent quarter or year-to-date, broken down by security type and dealer quintile.

• Action
  Get primary dealer survey by time series

  Returns Primary Dealer Statistics survey values for one or more time series across all series breaks.

• Action
  Get SOMA holdings summary

  Returns the System Open Market Account (SOMA) holdings totals by security type (bills, notes and bonds, TIPS, FRNs, MBS, CMBS, agencies) for each as-of date.

• Action
  Get Treasury holdings by as of date

  Returns the Treasury securities held in the Fed's System Open Market Account (SOMA) on a given as-of date, with CUSIP, maturity, par value and security type for each.

• Action
  List latest rates by type

  Returns the most recently published secured or unsecured reference rates from the New York Fed.

• Action
  List reference rates

  Returns the most recently published secured and unsecured reference rates (SOFR, BGCR, TGCR, EFFR, OBFR and the SOFR averages and index).

• Action
  List SOMA as of dates

  Returns the list of all as-of dates for which System Open Market Account (SOMA) holdings data is available.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.