Energy Information Administration publishes an impressive collection of data accompanied with features to view and access them. Data series can be downloaded one at a time. For more demanding use cases there is the API for software developers. All said, there is no intuitive option to easily connect and use this data set in major categories specifically in Excel and modern Business Intelligence platforms like Power BI. OilStat Data Connector bridges this gap. You can view and search for the categories you are looking for. All the series in the categories you selected then can be easily accessed with one query.
OData is a data access technology that utilizes existing Web protocols like HTTP to connect and query data. It has been formally standardized by major IT companies and is supported across multiple platforms and applications. This includes most of the Business Intelligence (BI) platforms, Excel and ERP systems. It is also noteworthy that you do not need any additional tweaks if your queries are done behind your corporate firewall. Connecting to OData is through HTTP which is the same way you view and navigate the Web.
No add-on is needed to access the data series. OData connection provider is built into Excel and most Business Intelligence platforms. There are also some Enterprise Resource Planning (ERP) systems that support connecting to OData data sources out of the box with no additional tools or configurations.
Our provider supports querying and previewing commands of a typical OData client which should be enough for most of the use cases. In more advanced scenarios, you may need to filter or group the data. We have implemented the Date Filter option to allow you quickly filter the data based on your selected date criteria at the source. This has been described in the Applying Date Filter Options section above. For all other filtering / grouping applicationas you need to load all the data and apply the intended operation with the functionality of the client software and do not rely on OData commands.
You can access all the data series published by EIA through their Open Data platform with a count of around 1.2 million.
No, you don't. Your query will be applied against a cache repository that is not connected to the EIA data source directly. This repository updates nightly.
Please contact us with your feedback. We appreciate it and may be able to tweak and enhance our offering based on it.