| **Navigation:**  SQL Drivers > SQLAnywhere Accelerator >====== SQLAnywhere Accelerator Synchronizer Login Dialog ====== | [[sqlanywhere accelerator  synchronizer server.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sqlite driver.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

Clarion's Dictionary Synchronizer Wizard (Enterprise Edition) lets you import an entire SQLAnywhere database definition into your Clarion Data Dictionary in a single pass. During this process, the Synchronizer Wizard opens an SQLAnywhere login** **dialog. This dialog collects the connection information for the SQLAnywhere database.

Fill in the following fields in the login** **dialog:

| **Database** | Select the SQLAnywhere database that contains the tables or views to import. If the **Database **list is empty, you may type in the name. See your server documentation or your DBA for information on database names. |
| **Username** | Type your SQLAnywhere Username. See your server documentation or your DBA for information on Usernames. |
| **Password** | Type your SQLAnywhere Password. See your server documentation or your DBA for information on Passwords. |
| **Include System Files** | Select this option to include system tables in the list of importable objects. |
| **Exclude System Files** | Select this option to exclude system tables from the list of importable objects. |
| **Other Filter** | Select this option to provide a filter expression to limit the list of tables and views to import. The filter expression queries the SYSCATALOG view. The filter expression is limited to 1024 characters in length. **The filter is case sensitive, so type your filter value accordingly.** |

Following is a list of the column names (and their Clarion datatypes) you can reference in your filter expression. See your SQLAnywhere documentation for information on these fields.

| CREATOR | STRING(128) |
| TNAME | STRING(128) |
| DBSPACENAME | STRING(128) |
| TABLETYPE | STRING(10) |
| NCOLS | LONG |
| PRIMARY_KEY | STRING(1) |
| CHECK | STRING(32767) |
| REMARKS | STRING(32767) |