Connecting RFA RDM to MSSQL
Hello, i'm currently using RFA API for getting Market Price RDM in some currency, question is: Is it possible to get the price (e.g BID and ASK) and send it to MSSQL Server Database? If possible, is there any example to achieve it? Thanks..
Best Answer
-
Hi @edo11,
Yes, it is possible to store price data to an MSSQL database. In general, once you have acquired the data within your own application, you have complete control over how you want to process that data, which includes using any other 3rd party technology to do this. The Refinitiv APIs are strictly used to acquire the real-time content from our servers. We don’t have any APIs or examples for sending prices to a database.
If this is new development you are considering, I would encourage you to look at our strategic Elektron APIs. They provide much easier interfaces and are our APIs that will constantly evolve, providing new features and capabilities. The RFA APIs are in maintenance mode only and will not include any future enhancements.
0
Answers
-
@nick.zincone when i running the RDM program i get the bid and ask market data that being typed to the log file, is there any way to store the data into some of variable, so i can continue the process to database? thanks
0 -
We have no knowledge of your RDM program and what it does. Based on what you specified, the developer decided to log some market data values (bid/ask) to a log file. In order for the program to do this, the market data values were received, likely stored in some variables, then sent to the logs. You, or the developer, will have to modify the program to send these values to a database.
Another possible option is for you to tap into the log files and take the values from there and send to a database. There are many ways you can do this - from building your own application that monitors these logs or to utilize some event processing 3rd party software that has the ability to monitor logs and send to a database.
0 -
Hi @edo11,
I'm following up to see if the answer to your question helped. If not, please provide some additional detail.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.5K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 560 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 281 Open PermID
- 46 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 724 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛