Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by andrey.zhdanov · Mar 03, 2017 at 09:58 AM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonpricingsql

Connecting MS SQL Server 2014 to EIKON services

We are trying to establish a live link that will help us to retrieve TBA pricing by using MS SQLS 2014. There is a report built in SSRS on our side that requires live pricing feed. What is the most efficient way of solving this?

People who like this

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

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Olivier DAVANT · Mar 13, 2017 at 08:48 AM

Hi @andrey.zhdanov,

If I understand well, you would like to feed your MS SQL database with TBA prices retrieved from Eikon and then use SSRS (SQL Server Reporting Services) to build reports from the data you captured in the database.

I don’t think the Eikon Scripting API is appropriate for this use case. Indeed, from a contractual point of view, the data retrieved via Eikon is intended for a single user and should not be redistributed via a database.

The Elektron platform and APIs Zoya mentioned above are probably more appropriate for your use case. In order to feed your database you will have to build an application that consumes Elektron real time data and populates your database with it. To consume the data, the application will have to use one of Elektron APIs (EMA or ETA) that are available for the C, C++ and Java programming languages.

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 zoya faberov · Mar 03, 2017 at 02:04 PM

Hello @andrey.zhdanov,

Sounds like what you are researching a price feed to meet your realtime data requirements and an API to subscribe to it.

Elektron is a price feed that allows to subscribe to various pricing from around the world, and is part of Elektron Platform, for additional info:

Elektron

On TR developers portal there is info about Elektron suite of APIs,

Elektron Message API (EMA) in C++ or Java is a high level API that is strategic, straightforward to learn and use, and an efficient way to reach your goal of subscribing to realtime data, that you can store for future retrieval using MS SQL Server.

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 andrey.zhdanov · Mar 28, 2017 at 01:34 PM

Thank you all very much for clarifying the matter.

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 >
11 People are following this question.

Related Questions

Trying to fetch Close Bid Price for CMO tranche from Python

How to get all investors for a list of stocks, historically with the python API

What is the best way to retrieve Open Interests Data and what is the API, language its hosted ?

What currency does the API function get_data report market cap info?

last trading price is 0 when market is closed for GILD.OQ

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges