How do I connect to an SQL Server database?
Created On
bydwilder
Print SimpleIndex has the ability to export, query or autofill from an SQL database. This allows you to upload data that is indexed with SimpleIndex to a table or view, search against the database or pull information from the database based on a key value.
Insert New Data
- Open the Job Settings Wizard and go to the Database step
- Set the Database Mode to Insert New Records
- Click the “New Data Source…: button
- Select the SQL Database radio button and click Next
- Fill in the “Server:”, “Database:”, “Username:” and “Password” for the SQL Database
- Click the “Build” button to generate the Database Connection String
- Click the “Test” button to confirm SimpleIndex is connected to the Database properly
- Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
- Link all of the fields in SimpleIndex to the columns in the database that they should Insert to
Search Existing Data
- Open the Job Settings Wizard and go to the Database step
- Set the Database Mode to Retrieve and View Records
- Click the “New Data Source…: button
- Select the SQL Database radio button and click Next
- Fill in the “Server:”, “Database:”, “Username:” and “Password” for the SQL Database
- Click the “Build” button to generate the Database Connection String
- Click the “Test” button to confirm SimpleIndex is connected to the Database properly
- Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
- Link all of the fields in SimpleIndex to the columns in the database that they should Insert to
Autofill Based on Key Values
- Open the Job Settings Wizard and go to the Indexing & File Naming Step
- Click the “Autofill Settings…” button
- Select the SQL Database radio button and click Next
- Fill in the “Server:”, “Database:”, “Username:” and “Password:” for the SQL Database
- Click the “Build” button to generate the Database Connection String
- Click the “Test” button to confirm SimpleIndex is connected to the Database properly
- Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
- Select the key field for the database column in the “Database Key Field 1:”
- Select the key field for the SimpleIndex index field in the “Index Key Field 1:”
- Set-up the Autofill fields that need to be filled in based on the key field