Technical Note: 20050331130
SQL Bridge
(Maitre'D 2005 and later versions of Maitre'D)
You
can export data straight to a SQL Server through Corporate Communication,
either from the Corporate Office or from each individual restaurant.
Corporate Communication Server / SQLBridge
Enable SQL Bridge
Enable this option to interface the corporate office with a SQL server.
Enable this option to interface the restaurant with a SQL server.
Provider
Select SQL Server.
Server
Enter the address of the SQL Server.
Database
Enter the name of the SQL database.
User
Enter your user name on the SQL Server.
Note: To create a new SQL database, a user with database creation rights
must be used. For subsequent accesses to the database, a lower level can
be used. Also, SQL Authentication is mandatory. Windows Authentication
is not sufficient.
Password
Enter the password associated with the above user name accessing the SQL
Server.
Log Level
Select in this field to start a log of all SQL connection operations, and
how detailed you want it to be.
Test Connection
Click this button to test your connection with the SQL Server. The SQL
server must visible across the network.
Corporate Communication Client / SQLBridge
