Synchronising from an SQL Database

Description

This tutorial describes a step-by-step guide demonstrating how to synchronise records from an SQL database.

Resources

• DemoCustomer.bsp
• TestBrightXpress.bep

Steps

1. Create a new DEMO_CUSTOMER table in the SQL database to match the fields defined in DemoCustomer.bsp’s table. This may be achieved by using the 'Create Tables' method in BrightBuilder, selected from the table's context menu.

   

2. Create 2 records in the SQL database’s DEMO_CUSTOMER table.

3. Start BrightBuilder.

4. Open TestBrightXpress.bep.

5. Create a new Sync Point by right clicking on the 'Sync Points' panel.

   

6. Drag a Client table sync point () from the toolbar on to the Sync Point panel.

7. Select the new SyncPoint and set DEMO_CUSTOMER as the Client Table.

   

8. Drag a Database data accessor () to the panel. Rename it to 'SQLExpress'.

9. Set up the database’s properties to match the previously created SQL database.

10. Create a data flow by holding the keyboard CTRL button, and dragging the mouse from the Database SQLExpress point to the Client DEMO_CUSTOMER sync point. Release the mouse once the two are attached.

    

11. Run the modified TestBrightXpress.bep on a debug server instance by right clicking it and selecting “Execute”. This may also be achieved via () or by pressing F6.

12. Open DemoCustomer.bsp and execute it in BrightForms.

13. Within BrightForms, ensure the username, password and server IP address information for the debug BrightServer instance is configured correctly.

14. Click 'Get' button to download records from server.