Using the Data Connection Wizard

 In order to import data from LDAP (Active Directory), Oracle, SQL Server, SAP (HR-OCI), OLE DB or ODBC compliant data source, the Import Wizard requires a Data Connection file. You can use the Data Connection Wizard, which automatically opens when you select one of these data source types within the Import Wizard, to create a Data Connection file.

The Data Connection Wizard is described in the following steps:

·         Creating a Data Connection File

·         Selecting the Table/View

Creating a Data Connection File

In order to access an external data source, you must create a data connection file. A data connection file contains all the configuration details required to connect to an external data source.

To create a Data Connection file:

1        In the Import Wizard, select one of the following data sources and click Next.

·         ODBC DSN

·         OLE DB

·         Oracle

·         SQL Server

·         SAP (HR-OCI)

2       The Data Connection Wizard opens. You are prompted based on which data source you selected. You may be required to select a database file or to login to a database server.

If you select ODBC DSN

1        Select the ODBC Data Source and click Next.

2        Depending on the ODBC Data Source you entered, you may be required to select a database file or to log in to a database server.

3        Click Next.

If you select OLE DB

1        In the Connection String field, enter a connection string.

2        Enter the User Name and Password.

3        Click Next.

Note: More detailed information on OLEDB is available in the OrgPlus Support Center (www.orgplus.com/support).

If you select Oracle

1        In the Service Name field, enter the required service name.

2        Enter your Oracle User Name and Password.

3        Select whether you want to browse for a database and table/view or whether you want to specify a database and table/view.  If your login account has access to a large number of databases or tables/views, downloading a complete catalog to browse may be time consuming.

4        Click Next.

If you select SQL Server

1        In the Server Name field, enter a server name.

2        Select one of the following Log on credentials:

·         Use Windows Authentication

·         Use the following User Name and Password, and enter the User Name and Password.

3        Select whether you want to browse for a database and table/view or whether you want to specify a database and table/view. If your login account has access to a large number of databases or tables/views downloading a complete catalog to browse may be time consuming.

4        Click Next.

If you select SAP (HR-OCI)

1        Enter all the SAP Connection parameters.

2        Click Next.

Note: The SAP HR-OCI connection is an add-on module to OrgPlus Professional and OrgPlus Premium. More detailed information on SAP HR-OCI is available in the OrgPlus Support Center (www.orgplus.com/support).

Selecting the Table/View

After you have selected the data source, the Tables/Views dialog box is displayed (if you did not specify a table/view in the previous step), which lists the views or tables available from the selected data source.

Note: If you selected SAP HR-OCI you will not need to select a table or view or if you specified a database and table/view in the previous wizard step.

To select a table or view:

1        Select the table or view that contains the source data.

2        Click Next.

The Result dialog box displays data from the selected table/view. If the data is incorrect or an error occurs connecting to your data source, click Cancel and repeat the process making sure you select the correct table/view and that all parameters are entered correctly.

If required, use the Browse button to change the name or the path that will be used to save the Data Connection file.

Note: If you are planning to use automation to refresh your data, make sure to select the Save password in file checkbox. Otherwise, you will be prompted to enter the password each time you connect to the database.

3        Click Next to save the Data Connection file and resume the Import Wizard process.