Is there any Refinitiv API that connects directly to a database? ideally SQLite, Without using th...

...e Python API or Excel
We are looking to ideally use Refinitiv function within SQL in an SQLite database
Best Answer
-
I'm not sure I understand your use case. If you would like to retrieve Refinitiv data and store it in a your own SQL database, then technically pretty much any Refinitiv API could be used in this scenario. For instance you could use Refinitiv Data Platform Library for Python to retrieve the data and then use sqlite3 library to write it into your SQLite database. What you should be mindful of is whether the Refinitiv product you subscribe to permits such data utilization. E.g. with Eikon subscription, any data retrieved from Eikon is licensed for individual user's use only. Storing the data retrieved from Eikon in a database that is accessed by multiple users or by any kind of enterprise application would be inconsistent with the data license granted with Eikon. In this case you should consider subscribing to one of Refinitiv enterprise products that permit the data utilization in the manner you intend to implement.
However, if you're asking whether you can retrieve Refinitiv data using SQL, there are some products that offer such capability, e.g. Refinitiv Quantitative Analytics. However, the majority of Refinitiv products do not provide direct access to databases of record for Refinitiv content assets (or to any databases for that matter). Instead data retrieval is typically provided through Web services using REST or SOAP APIs or using client side libraries like Refinitiv Data Platform Library.0
Answers
-
Thank you @Alex Putkov.1 for the Answer. It is useful. A question, If I'm in my database, Is the any way to connect my database to Refinitiv and get data, for example, Select MyTable.*, GetRefinitivprice( id, date) FROM MyTable without using the python api, but connecting directly from my database?
0 -
I'm afraid I cannot provide a comprehensive answer to this question, as it requires intimate knowledge of whatever application you utilize to manage your database, which I do not possess. If you subscribe to Refinitiv Quantitative Analytics, you likely should be able to use your database management application to retrieve data from the SQL database provided by Refinitiv Quantitative Analytics. Although I cannot be certain, as I have no knowledge of the application you use. This application may also provide capability to retrieve data from Web services, but again I cannot comment on that, as I have no knowledge of whatever application you use to manage your database.
I think you may be better off engaging a Refinitiv Solutions Consultant or a Sales Specialist, who can assess your setup, your data requirements and recommend Refinitiv product that best suits your use case. To engage a Refinitiv Solutions Consultant or a Sales Specialist, contact your Refinitiv account manager or visit https://www.refinitiv.com/en/contact-sales0
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
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 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
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛