How can we help you?

Take control, streamline configurations, and unlock insights – all in one place.

Control Hub is an all-in-one web-based management tool purpose-built for clients using Preetech Solutions. It replaces the need for direct database access, empowering councils and organisations with a secure, intuitive, and feature-rich platform to manage, monitor, and gain valuable insights from their integration solutions.

🧩 Seamlessly Integrated with Preetech Solutions

Control Hub is designed to work out-of-the-box with all Preetech integrations, including:

• Snap Send Solve ↔ CRM
• Close The Loop Tool
• Email to CRM Integration
• CRM To Email Integration
• Waste Integration

Step 1: RDP to Server where Preetech solution is installed and configured.

Step 2: Open Windows Services.

Step 3: STOP the Preetech solution windows service (e.g., Preetech Close The Loop tool).

Step 4: Open File Explorer/My Computer.

Step 5: Navigate to Preetech solution installed directory.

E.g., C:\Program Files(x86)\Preetech\Close The Loop\

Step 6: Backup the existing config file.

Step 7: Open config file in text editor (e.g., Notepad).

Step 8: Search for string "Preetech_APIKEY"

Step 9: Copy the new API Key received from Preetech.

Step 10: Paste the new API Key in attribute “Preetech_APIKEY”.

Step 11: Save changes to config file.

Step 12: START the Preetech solution windows service (e.g., Preetech Close The Loop tool)

Step 1: RDP to Server where Preetech Web service is installed and configured.

Step 2: Open File Explorer/My Computer.

Step 3: Navigate to Preetech Web service installed directory.

E.g., C:\inetpub\wwwroot\\

Step 4: Backup the existing web.config file.

Step 5: Open web.config file in text editor (e.g., Notepad).

Step 6: Search for string "Preetech_APIKEY"

Step 7: Copy the new API Key received from Preetech.

Step 8: Paste the new API Key in attribute “Preetech_APIKEY”.

Step 9: Save changes to config file.

Step 1: Login to Control Hub

Step 2: Navigate to Configuration

Step 3: Select the Product for which you need to update the API Key

Step 4: Click on "Select" button on rown where attribute name is "PREETECH_APIKEY"

Step 5: Enter new value/key received from Preetech

Step 1: Login to Control Hub

Step 2: Navigate to Configuration

Step 3: Select SSS from the Product and click display.

Step 4: Click on "Select" button on rown where attribute name is "SSS_START_DATE"

Step 5: Enter the value in format YYYY-MM-DD (e.g.,2025-01-01) to pull SSS reports from 01st Jan 2025

Step 6: Click on "Select" button on rown where attribute name is "SSS_END_DATE"

Step 7: Enter the value in format YYYY-MM-DD (e.g.,2025-01-10) to pull SSS reports to 10th Jan 2025

1. Create MS-SQL Database "PREETECH":

   • Open SQL Server Management Studio (SSMS).

   • Right-click on the "Databases" folder and select "New Database."

   • Name the database "PREETECH" and configure any additional settings as needed.

2. Create SQL Login "SQLPREETECH":

   • In SSMS, navigate to the "Security" folder.

   • Right-click on "Logins" and select "New Login."

   • Set the login name to "SQLPREETECH" and configure the authentication method (i.e., SQL Server authentication).

   • Set a secure password for the login.

3. Assign DB_Owner Access to SQL Login "SQLPREETECH":

   • In SSMS, navigate to the "Security" folder.

   • Expand "Logins".

   • Right-click the "SQLPREETECH" login and select "Properties."

   • In the Properties window, select "User Mapping."

   • Select the "PREETECH" database and check the db_owner role in the "Database Role Membership" section.

   • Click "OK" to save the changes.

4. Share the DB and Credentials Details:

   • Once the setup is complete, please share the following details securely using Preetech Secret Share

   • Database Name: PREETECH

   • SQL Server Name/IP Address: [Server Name/IP]

   • SQL Login: SQLPREETECH

   • Password: [Password you set for the login]