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?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●1 ●0 ●2
Connecting MS SQL Server 2014 to EIKON services
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi @andrey.zhdanov. Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
942
●8 ●9 ●13
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.
32.2k
●40 ●11 ●20
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:
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.
