The purpose of this article is to explain how you can connect DotActiv Pro or Enterprise to your own SQL database.
Creating A DotActiv Database
When you use DotActiv Pro or Enterprise for the first time and you want to connect it to your SQL database, please follow the below steps.
Step 1: Open DotActiv
Step 2: Be sure to check the box next to ‘Select Database’
Step 3: Enter your username and password and click ‘OK’
Step 4: You will be prompted with a ‘Select Main Database’ window. Here, select ‘New’.
Step 5: Select your database type. The most popular is ‘MS SQL’
Step 6: Next, select your Open Database Connectivity (ODBC) driver. The most popular one used is ‘SQL Server’.
Step 7: Click ‘New Database’ and give your database a name. For example, DAMyDatabase.
Step 8: Enter your SQL Server login details. Please speak to your IT department or the relevant person at your company for these details if you do not have them on hand.
Step 9: Once you have entered your details, you should receive the following screen informing you that your DotActiv will be setup.
Step 10: The DotActiv software will now build your new database with the necessary structure. Once done, you should receive the following screen
Step 11: To confirm that all was successful, you can look at the footer of your DotActiv software to see if your DotActiv is connected to the database you created.
You have not successfully set up a brand new database for your DotActiv.
Matching Configurations To DotActiv
It is important to note that your configuration (FLP Format) matches you DotActiv. If you make changes in your database regarding your FLP format, it must be on par with your DotActiv software.
To ensure that happens, please follow the below steps.
Step 1: Click on ‘File’, then ‘Setup’ and ‘Application Settings’.
Step 2: Select ‘FLP Format’ in the Application Settings window.
Step 3: Click ‘Refresh’ in the Planogram Format Setup window that appears. This will, in turn, update your values from the database.
If the above steps not work for you, please create a support ticket and DotActiv support will assist you in uncovering the issue.