The External DB option on the Create Data Table page lets you connect to an external Microsoft SQL Server (MSSQL) or PostgreSQL database. It enables you to use live data from your existing database without storing it again.
Now, let’s explore some practical scenarios where connecting an external database makes managing and updating data easier.
¶ Use Case
¶ Scenario 1: Connect Warehouse and Factory Data
Streamline warehouse operations by linking your app to the factory’s database.
- View real-time stock levels and shipment updates instantly.
- Automatically update records when the factory processes new shipments or stock changes.
- Set up alerts for reorders to prevent stock shortages.
This integration eliminates manual tracking and keeps warehouse management smooth and efficient.
¶ Scenario 2: Integrate Your CRM (Customer Relationship Management)
Keep customer data accurate and accessible by connecting your CRM system.
- Sync customer details—names, contacts, and order histories—seamlessly.
- Automatically update records whenever changes occur in the CRM.
- Enable teams to provide seamless support with up-to-date customer information.
This setup saves time and ensures consistent data across all teams.
¶ Scenario 3: Automate Inventory Management
Track inventory efficiently by linking your stock database.
- Display real-time stock levels in your app.
- Automatically update inventory data when items are sold, or new stock arrives.
- Reduce manual data entry and minimize errors.
This integration simplifies inventory tracking and ensures reliable data for decision-making.
Example Connection String
Data Source=172.162.12.36;Initial Catalog=QuixyTest;User ID=sa;Password=n@v@yUg@kw!x##Breakdown:
- Data Source: Server IP address (e.g., 172.162.12.36). This may change if the server or IP is updated.
- Initial Catalog: Name of the database being accessed (e.g., QuixyTest).
- User ID: Username used for login (e.g., sa for system administrator).
- Password: Password for the username. Use a strong, secure password to protect access.
After entering all connection details, click Test to verify the setup.
Once the test is successful, click Save to store the connection.
To set this as the default for future use, select Set as Default before saving.
Once the connection is created, you can build data tables using live data from the external database.
Learn more how to Create a Data Table Using External Database.