Dotactiv-ALL IN ONE CATEGORY MANAGEMENT SOFTWARE-BG.jpg

Data Integration

What is Data Integration?

Data integration is the process whereby retail data (Sales, Stock, Market, and Product) is pulled from different sources - POS database, ERP or SAP - and placed into staging tables, which can be automatically processed by DotActiv’s software.

 

Data Integration Intro-03

 
 
Why is Data Integration necessary?
 
Practical Benefits
 
How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-38A simplified category management process: Not integrating your category management efforts makes it harder to execute any changes accurately.

How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-26Reduced complexity of processing your data: Since data is imported and exported automatically, you don’t need to format and transfer data manually.

How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-25Increase the value of your data: By combining your retail space and category management data with other datasets, you can extract more value from your data.

How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-50Your data is more accessible: Once integrated with DotActiv, your data is available in its more raw format. We can also set up an automated data transfer to other systems if you want that.

 
FINANCIAL BENEFITS
 
How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-48Reduced labour costs: Once set up, importing and exporting data is automated, thus reducing labour costs.
 

How Retailers Can Take Advantage Of Today’s Retail Marketing Landscape-Icon-43Reduced errors: Since the transfer of data is automated; you can reduce the costs associated with human error.

 


How DotActiv does data integration

Dotactiv-Category Management-Professional 

DotActiv Pro and Enterprise solutions come standard with an integrated database so that you have a seamless flow of data to and from your software, saving you time and improving your accuracy.

Our technical support team delivers this database integration service, which comes with a money back guarantee, capped at the total value of your first years' billing of software. 


 

Data-04.png
DotActiv’s Data Platform and Integration Approach
  • Add custom data fields on the fly: DotActiv's data platform allows you to add multiple custom fields to your database. While already populated with standard formulated fields, you can also bring in your unique data.
  • Import from multiple datasets: You can import data from and to various data sources.
  • Scalability: DotActiv is built on SQL, so we offer scalability. This scalability is limited to the hardware and software you use.
  • Integration as a service: DotActiv follows an eight-step process, working hand-in-hand with your IT department.
  • Security: Our data integration process happens within the retailer's environment and thus falls under the security protocols of that organisation. We also provide you with one license, which is installed on your server so that there are no issues with how your data is updated or extracted.
Integrated-Banner copy
                                                                                                                                                              

The DotActiv Data Integration ProcesS

 DotActiv follows an eight-step process, working hand-in-hand with the customer's IT department. In brief, these steps are: Scope Meeting, Deploy the Server, Deploy DotActiv Database, Deploy DotActiv Data and Planogram Import Utilities, Populate Stating Tables, Testing, Sign Off, and Go Live.

 

SCOPE MEETING-04

 1. SCOPE MEETING

DotActiv and the customer’s IT team meet to discuss the project, scope and list of responsibilities for each party.

Estimated time: 1 to 2 working days.

 

 Server-05

 

2. DEPLOY THE SERVER

You are responsible for deploying a dedicated server. Minimum specs for the server include a 3Ghz dual-core CPU, 16gb ram, and 300gb HDD. Software requirements include Windows server 2012 or later, Microsoft SQL Server 2014 or later, and IIS7 and dotNet4.5.

You are responsible for providing DotActiv’s IT team with remote access as well as a dedicated SQL username and password. Estimated time: 10 working days.

Database2-04
3. DEPLOY DOTACTIV DATABASE

DotActiv is responsible for the deployment of the DotActiv Databases to the new server along with the required staging tables.

Estimated time: 3 working days.

 

DEPLOY DOTACTIV DATA AND PLANOGRAM IMPORT UTILITIES-05
4. DEPLOY DOTACTIV DATA AND PLANOGRAM IMPORT UTILITIES

DotActiv is responsible for the deployment and configuration of the supporting applications for integration. You are responsible for providing a shared folder on the server for use by DotActiv’s space planning team.

Estimated time: 1 working day.

POPULATE STAGING TABLES-04
5. POPULATE STAGING TABLES

You are responsible for setting up and maintaining scripts to populate the staging tables with data in the correct format.

Estimated time: 10 to 15 working days.

Test-05
6. TESTING

DotActiv will test that the initial data in the staging tables are correct and provide feedback where necessary. You will be responsible for ensuring the server and data feeds are stable and accurate.

Estimated time: 2 to 4 working days.

Sign Off-04
7. SIGN OFF

Both DotActiv and the customer are responsible for sign off on the integration.  

Estimated time: 1 working day.

Launch-05
8. GO LIVE

The customer is responsible for clearing any test data from the staging tables, implementing the finalised scripts, and populating the staging tables with production data.

DotActiv is responsible for removing any test data from the DotActiv system and turning on the automation of the Data Imports.