SQL Connector |

|
The Microsoft SQL panel connector will let you connect any SQL Server table or view as a panel inside FeedbackServer. Once connected it will synchronize the information available in the source table with the local FeedbackServer database.
Its important to note that if you synchronize a set of users starting from 50k with a many columns (5+) you must make sure that your local FeedbackServer database has enough space available for the synchronized data and for the transaction log its SQL Server before synchronizing.
Following SQL Server column types are currently supported for synchronization :
- bigint
- int
- smallint
- tinyint
- bit
- decimal
- numeric
- money
- smallmoney
- float
- real
- datetime
- smalldatetime
- char
- varchar
- text
- nchar
- nvarchar
- ntext
User defined types are also supported if they are based on any of the supported types above.
SQL Connector Settings
Make sure to ask your local system administrator for the correct settings if you have any doubts.
- Authentication Mode is how the connector will connect to our SQL Server
-
- SQL Authentication : Uses SQL Server's user ids and passwords.
- Integrated Security : Users the current user which runs the ASP.net worker process.
- Connection String : Supports any valid SQL Server connection string
- SQL Server Name is the name of our SQL Server that will hold the table we want to connect to.
- User Id is the SQL User id to connect to our SQL Server
- User Password is the password of the SQL User
- Table To Connect To The panel is the list of tables available from which we can choose the table to connect to.
- The account connecting to the database must have a least read access to the table in order to see it in this list.
- Map panelists id to primary key is the name of the primary key of the table to which we will connect.
- Table columns to synchronize is the name of the columns that are available for synchronizing. Its important to remember that the more columns we choose the bigger the synchronization will get.
Supported Panel Connector Modes
- Read Allows to synchronize structure and data from a SQL table
- Update Allows to update existing data in the connected SQL table
Known Limitations / Issues
The SQL Connector has some limitations listed below :
- One primary key only table with a single primary key are supported at this time
- No Structure changes its not possible to add new columns for syncronizing once the panel has been created