Configuring the index service manually

You must run the iBase indexer on a computer with a network connection to the SQL Server instance that contains the iBase database to index.

To set up a search 360 index for a database stored remotely:

In iBase Designer, enable Search 360.

Open a command prompt and run the iBase indexer. For example:

"i2.iBase.SearchIndexerExe.exe" /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "password" /FullReindex /ShowSummary

The following arguments are valid, but can't all be used at the same time.

Note: Newly upsized databases in iBase 10 have a randomly generated Database Access Token that must be supplied to Search 360 in order to connect to SQL Server based databases. You can locate your DAT string in iBase Designer. Go to the Database Access Token tab on the Database Properties page, and click Copy. An example DAT argument is provided below.

iBaseDBName

The name of the iBase database as stored in SQL Server.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"

ServerName

The server name and SQL instance to access.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"

Username

The username used to access the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"

Password

The password used to access the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"

FullReindex

This argument can be added to reindex the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /FullReindex

Database Access Token

This argument is required to provide the Database Access Token for iBase 10 databases.

"i2.iBase.SearchIndexerExe.exe" /iBaseDBName "YourDatabaseName" /ServerName "YourServerName" /Fullreindex /DAT <DAT>"

Here is an argument with an example Database Access Token (DAT) value. Note each database has its own unique DAT.

"i2.iBase.SearchIndexerExe.exe" /iBaseDBName "YourDatabaseName" /ServerName "(local)\SQL2019" /Fullreindex /DAT CE+Q8EtNRZZG1NWTNUCQW8ZFcv6T9gQxLneC8Eiy48754Roij0cWpxWqa4Nog6

ShowSummary

This argument can be added to display a summary of the state of the index after the process finishes.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /ShowSummary

Pause

This argument can be added to pause the indexing at the end of the task that is being processed.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /Pause

DisplayRecordId

This argument can be added to display the Record ID as each record is processed.

Note: Depending on the number of records that are being processed, displaying this information might have performance implications.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /DisplayRecordId

DisplayCallstack

This argument can be added to display the SQL command call stack if an error occurs.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /DisplayCallstack

TrustServerCertificate

This argument can be added to trust the server certificate when connecting to the SQL Server instance.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /DAT "DAT token"/TrustServerCertificate