SQL External Bindings

SQL External Binding support was added in GlobalSearch 6.1.103.

In this example we’ll use the ssMaster.dbo.ssConnectionStrings table to return a list of the GlobalSearch databases connected to your GlobalSearch instance.

You can learn how to check your GlobalSearch version by reading our Determine Software Version knowledge base page

Navigate to the Field Catalog and then the Lists Subsection
Create a new list and turn on the External Binding option
Select SQL Query from the drop down

Connection Strings

You can read more about the options available for SQL Server Connection Strings at the link below;

https://www.connectionstrings.com/sql-server/

For security reasons you cannot use “Integrated Security” or “Trusted_Connection” in your connection strings. You will need to create a SQL Authentication user and pass in the username and password via the Connection String

A typical SQL Server connection string can be found below;

Server=(local);Database=ssMaster;User Id=globalsearch;Password=globalsearch;

SQL Query

GlobalSearch will use the first column returned from the SQL query to populate the list, it will ignore all other information returned.

select Name from ssMaster.dbo.ssConnectionStrings