...

Create Links to External Data XChange Sources

1. To set Data XChange sources, on the GlobalSearch toolbar, in the Administration menu, select Administration.

2. In the vertical Administration menu, select Archives. A list of Archives will appear.

3. Click the More Options ( ) icon for the selected Archive and select Data XChange.
   

   Image Modified

4. Click New.

5. In the Data XChange Source dialog that appears, enter the name of the source in the Source Name text box. Use a short but descriptive name to indicate to users what Data XChange source is being used for updating. 
   

   Image Modified

6. Enter the connection string in the Connection String text box. The data source can be in a file format where a connection string can be created, such as CSV file, a SQL table, or an Access database.

7. Alternately, if you are doing an internal lookup (select the Internal Database toggle). This option allows a Data XChange source to look into the current or a different GlobalSearch database without any special configuration, connection strings, or users.

8. Click Go.

9. Click the Select a data source Expansion (triangle) icon and in the Mapped Fields group, select one or more of the Archive Index Fields to map to from the list of available Fields. Note, if your chose Internal Database in step 7, the Data Source selector will be replaced with a list of GlobalSearch databases available in the environment.

...

1. Image Added

2. Click Save.

3. Click Close to close Data XChange Sources.

Modify External Data XChange Sources Settings

1. To modify links to external Data XChange sources, select Administration > Administration > Archives.

2. From the list of Archives, click the Options icon (three dots on the top right of the card) for the selected Archive and select Data XChange.

3. In the Data XChange Source dialog, select the source and click the Edit (pencil) icon and make changes to the settings.

4. Click Save to save changes and then Close.

Delete Links to External Data XChange Sources

1. To delete links to external Data XChange sources, select Administration > Administration > Archives.

2. Click the Options icon for the selected Archive and select Data XChange.

3. In the Data XChange Source dialog, select the source and click the Delete icon.

4. Click Close.

Example: Data XChange Connection String for SQL

...

With GlobalSearch 5.0.0 the above connection string is defunct because GlobalSearch has switched to be completely 64 bit and the above provider, Microsoft.Jet.OLEDB.4.0 is a 32 bit driver. Instead you need to install and use the 64 bit Microsoft.Ace.OLEDB.12.0, you can download the installer from; https://www.microsoft.com/en-us/download/details.aspx?id=1325554920 . Be sure to select the _x64 version of the installer when you start your download.

...