Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TREP APIs /
  • RFA /
avatar image
Question by edo11 · Aug 21, 2019 at 08:09 AM · connect

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..

People who like this

0 Show 1
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
nick.zincone.1 ♦♦ · Sep 04, 2019 at 06:25 PM 0
Share

Hi @edo11,

I'm following up to see if the answer to your question helped. If not, please provide some additional detail.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by nick.zincone.1 · Aug 21, 2019 at 08:48 AM

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by edo11 · Aug 21, 2019 at 11:04 PM

@nick.zincone.1 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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by nick.zincone.1 · Aug 22, 2019 at 09:27 AM

@edo11,

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

RFA7.2 failed to connect RMDS in different linux environment

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges