RetailSolutions connector · Retail & POS
RetailSolutions connector
With the DigiData RetailSolutions connection you automatically retrieve store data, personnel information and weekly reports to DigiData. Ideal for retail analysis, workforce planning and performance monitoring.
Here you will find the supported data, operation and availability of the connection. Follow the practical guide Use retail data in Power BI for the steps in Power BI.
Last reviewed:
The reason
Why connect RetailSolutions to DigiData?
The RetailSolutions connector synchronizes the operational tables listed on this page, including stores, store groups, employees, contracts, leave balances and weekly reports. Planned and actual hours can therefore be loaded into Power BI or Excel via OData. Analyzes outside this source data, such as turnover or margin, require a separate source and its own reporting model.
Connecting RetailSolutions to Power BI in short
The RetailSolutions connector is available and synchronizes supported tables such as Shops (Stores), Shopping groups, Store structure and Staff. DigiData offers these source records via OData for Power BI and Excel and via CSV for separate exports. The connector only supplies the entities listed on this page; source permissions, the source API, and your sync schedule determine which records and updates are available. You set up relationships, calculations and dashboards in the reporting tool.
RetailSolutions data for stores, weekly reports and planning
This connector focuses on operational retail data: stores, store groups, employees, contracts, leave and weekly reports with planned and actual hours.
Weekly reports
Sync stores, contracts, employees and weekly data to Power BI for recurring retail reporting.
Store and workforce analysis
Compare locations, occupancy and performance without separate files from different systems.
Available output
Use OData for recurring reports and CSV for defined checks per table or period.
Conditions
Availability, setup and conditions
- Availability
- Status: Available. The connector provides the entities listed on this page under "Available data".
- Setup
- Add RetailSolutions in the DigiData dashboard and configure access to the source. DigiData confirms during setup which accounts and entities are available.
- Refresh
- Automatic daily synchronization. New source data will not appear until the source sync and then the Power BI refresh are complete.
- Security
- API keys and tokens for linked applications are stored encrypted.
- Limitations
- Only the listed entities are supported. Availability and timeliness depend in part on the source API and your rights in RetailSolutions. DigiData supplies source data via OData and CSV; you set up relationships, measures and dashboards in the reporting tool.
- Price and trial period
- From €145 per month for the platform and one RetailSolutions link, without start-up costs. You can test DigiData 14 days for free. View current prices.
What you get
What do you get with the RetailSolutions link?
An overview of what DigiData does with your RetailSolutions data:
Which data
Available RetailSolutions data in DigiData
The following entities are automatically synchronized and available via OData or CSV export:
Use cases
What can you do with RetailSolutions data?
Compare store performance by region in Power BI
Optimize personnel planning based on historical data
Monitor leave balances per store or team
Benchmark analyses between stores and store groups
How it works
How does the RetailSolutions link work?
Connect RetailSolutions
Link your RetailSolutions account via the DigiData dashboard. Safe and fast.
Select your dates
Check which accounts, environments, and entities are available for this resource. The options differ per connector.
Analyze in Power BI
Use the OData feed in Power BI, Excel or download CSV exports.
RetailSolutions in Power BI
Create retail dashboards in Power BI with RetailSolutions data via DigiData. Store data, weekly reports, personnel planning and leave balances are available as OData tables. Compare store performance by region, analyze planned versus actual hours and monitor leave trends, all from a central Power BI dashboard.
Frequently asked questions
Questions about the RetailSolutions integration
How do I connect RetailSolutions to Power BI?
With DigiData you automatically synchronize RetailSolutions data to an OData feed. In Power BI Desktop, choose 'Get Data', select OData feed and paste the DigiData URL. You can then load, combine and refresh the tables without building a RetailSolutions API connection yourself.
How often is RetailSolutions data refreshed?
Automatic daily synchronization. The availability of new records remains dependent on the source API and your set synchronization schedule.
What does the RetailSolutions connection cost?
DigiData charges platform costs plus an amount per active integration. There are no start-up costs and you can test for 14 days for free. View the current price on the prices page.
What retail data is collected?
DigiData retrieves store data, employee data, contracts, competencies, leave balances and weekly reports from RetailSolutions.
Can I filter data per store group?
Yes, via the OData feed you can filter data by store, store group or region for targeted reports.
Combine
Other integrations that may interest you
Most companies do not run on one package. Place RetailSolutions next to your other sources, so that you have one report.
14 days free · no start-up costs
Ready to connect RetailSolutions to DigiData?
Use the trial period to validate the available tables, synchronization and your reporting model with your own data.
