The API provides another option for handling data imports that bring user-curated data directly into your implementations Stratum Data hub. Your imported data is available immediately in Viewer to build out Stratum views, charts, and dashboards. The other option is to use the Data Import interface within Stratum.Viewer, which has windows specific to setting up and processing imports.
The API can be used to process imports where the source of data is a local SQL Server database table or Azure cloud sources such as an Azure Blob Container, an Azure File Share, or an Azure SQL Database. Create, process, and check the status of those imports interactively from Viewer or by using the Stratum Cloud API’s URL calls.
Like Viewer, the API offers flexible approaches and helpful efficiencies for imports. The API can automatically map the selected source data to applicable targets (dimensions and measures) in your data hub. Alternatively, you can tell the API to use a Data Import template from Viewer for mapping.
The Stratum Cloud API also can be used by an app, website, or services – for example with an Azure portal’s Azure Data Factory. In that scenario, the API could be called upon to import data from an Azure Data Pipeline. Features specific to your implementation, in this case your Azure Data Factory, would be used either to run the API-driven import right away or to schedule it for processing later according to the event criteria within your app.
*Note: Existing knowledge and experience with API’s and Azure are required when working with the features noted above. For example, you’ll need to use your knowledge of your Azure implementation and API calls that use the URL POST method when using the Stratum Cloud Import API with an app, website or services, such as Azure Data Factory.