Databricks feed

Introduction Data Discovery Set up your data feed in the Macrobond management panel Use your Snowflake data feed MAIN_ENTITY [Table] REVISION [Table] SUBSCRIPTION [View] LATEST_ENTITY [View] Introduction You can access any of Macrobond’s time series data into your Databricks environment. The data feed is intended for production purposes with near real-time updates. Here’s how it … Continue reading “Databricks feed”

Snowflake data feed

Introduction Data Discovery Set up your data feed in the Macrobond management panel Use your Snowflake data feed Data Dictionary MAIN_ENTITY [Table] REVISION [Table] SUBSCRIPTION [View] LATEST_ENTITY [View] Introduction You can access any of Macrobond’s time series data into your Snowflake environment. The data feed is intended for production purposes with near real-time updates. Here’s … Continue reading “Snowflake data feed”

Data Web API feed – How to update time series?

Introduction Universe Update (get_many_series) Universe Update with Revision History (get_many_series_with_revisions) Polling for updates (SubscriptionList) Poll for and Retrieve updates (GetDataPackageList) Introduction This document outlines several methods to update your universe of time series leveraging the Macrobond’s Python library. Please note, if you are using other languages than Python, or prefer to define your own functions, … Continue reading “Data Web API feed – How to update time series?”

The Macrobond FactSet Data Provider

Introduction Requirements Enabling the FactSet Data Provider Working with FactSet Data Provider Series names FactSet Data Provider Enhancement FactSet OFDB Revoking access Introduction With the Macrobond FactSet Data Provider you can retrieve time series from FactSet if you have an account there. Requirements You must have a FactSet account that is enabled for the FactSet … Continue reading “The Macrobond FactSet Data Provider”

The Macrobond Data API for Python (Python wrapper)

Introduction Requirements Installation Keyring Error: failed testing username and password Working with Python wrapper Download one series (Basic usage) Download one series (Advanced usage) Extensive guide – more examples Introduction The Macrobond Data API for Python uses either the Macrobond Web REST API or the Macrobond Client data API to obtain time series with values and metadata. The API … Continue reading “The Macrobond Data API for Python (Python wrapper)”

SQL In-house – connection strings

Introduction Macrobond SQL Database connector configuration file includes a section specifying data provider database connection string and connection string. It’s unique to each database type. This page includes examples for most commonly used databases. MySQL and MariaDB Please install https://dev.mysql.com/downloads/connector/net/ and use: <sql:DataProvider> <sql:Name>MySql.Data.MySqlClient</sql:Name> <sql:ConnectionString> Server=address.of.the.server; Database=dbname; Uid=user;Pwd=pass;​ </sql:ConnectionString> <!– instead of Uid=user;Pwd=pass;​ you can use … Continue reading “SQL In-house – connection strings”

SQL demo Virtual Machine

Introduction Requirements How to connect? Accessing data Introduction You can test our SQL database connector functionality with three views of test SQL database. Requirements Our example utilizes the MySQL and requires .NET connector for MySQL. This will allow Macrobond to ‘talk’ to SQL database. You will also need xml path file which you will receive … Continue reading “SQL demo Virtual Machine”

The Macrobond FTP/SFTP data feed

Introduction Working with FTP data feed Data Delivery Data Set Selection Content Content of the Data Feed Folder Content of the Data Feed Files Series Metadata Series Observations Replaced Series – Aliases Generated files Subscription List files Feed Statistics files Introduction The Macrobond FTP/SFTP data feed allows automated integration of our economic and financial data … Continue reading “The Macrobond FTP/SFTP data feed”