How do I connect to an SQL Server database?
Wednesday, 28 February 2018
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
Related Links
- Published in Database & Retrieval
No Comments
How do I connect to an existing Access database?
Wednesday, 28 February 2018
SimpleIndex has the ability to export, query or autofill from an Access database. This allows you to upload data that is indexed with SimpleIndex to a table or query, 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 Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query 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 Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query 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
- Click the “New Data Source…: button
- Select the Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query that is being filled from
- 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
Related Links
- Published in Database & Retrieval