Importing from SQL Server

See CONNX SQL Server Module for information about ODBC data source names.

To import data from a SQL Server:

1. Go to the main online CONNX Data Dictionary Manager page.

You can select CONNX Data Dictionary from the home page or the tile menu on the top right.

2. Browse to the CDD you want to import in and open it.

3. Click the Import button.

4. In the Import Type window, select SQL Server from the dropdown menu and click OK.

5. In the Connection Information step, select the data provider you want to use.

Click the OLEDB Provider radio button and provide the following to use the OLEDB adapter:

Select a data provider from the Provider Name dropdown menu.

Enter a server in the Server Name field.

Enter a username for the database in the Username field.

Enter a password for the database in the Password field.

Enter any extended properties you want to use in the Extended Properties field. Click Next when you are done.

Click the ODBC Provider radio button and provide the following to use the ODBC adapter:

Select a DSN Name from the dropdown menu.

Enter a username for the database in the Username field.

Enter a password for the database in the Password field. Click Next when you are done.

6. In the Import Properties step, select the database you want to import from the dropdown menu and any import options you want:

Turn the Include System Tables option on to include system tables in the import procedure.

Turn the Get Statistics option on to identify table sizes.

7. In the Table Selection step, mark the tables you want to import in the Available Table(s) pane and press the arrow pointing to the right to move them to the Selected Table(s) pane.

You can use the search field in the Available Table(s) pane to filter the list of tables.

You can mark all tables in a pane by clicking the checkmark next to the Available Table(s) or Selected Table(s) entry.

You can move tables back from the Selected Table(s) pane by marking the tables and clicking the arrow pointing to the left.

8. Click Done to finish the import procedure.