question

Upvotes
Accepted
1 0 0 0

Is there any Refinitiv API that connects directly to a database? ideally SQLite, Without using the Python API or Excel

We are looking to ideally use Refinitiv function within SQL in an SQLite database

eikoneikon-app-studio
icon clock
10 |1500

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

Upvotes
Accepted
39.2k 75 11 27

@danilo.cuevas

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.

icon clock
10 |1500

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

Upvotes
1 0 0 0

Thank you @Alex Putkov. 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?

icon clock
10 |1500

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

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

Click below to post an Idea Post Idea