2023:Database Lookup (Lookup Specification) - Revision history

Randallkinard at 19:19, 21 November 2024

2024-11-21T19:19:51Z

← Older revision		Revision as of 14:19, 21 November 2024
Line 80:		Line 80:
	[[File:2023-Database Lookup - Configure the Database Connection 05.png]]		[[File:2023-Database Lookup - Configure the Database Connection 05.png]]
	<section end="how to create a data connection" />		<section end="how to create a data connection" />

	~~== Glossary ==~~
	~~<u><big>'''Data Connection'''</big></u>: {{#lst:Glossary\|Data Connection}}~~

	~~<u><big>'''Data Field'''</big></u>: {{#lst:Glossary\|Data Field}}~~

	~~<u><big>'''Data Model'''</big></u>: {{#lst:Glossary\|Data Model}}~~

	~~<u><big>'''Database Lookup'''</big></u>: {{#lst:Glossary\|Database Lookup}}~~

	~~<u><big>'''Lookup'''</big></u>: {{#lst:Glossary\|Lookup}}~~

Dgreenwood: Dgreenwood moved page 2023:Database Lookup (Lookup) to 2023:Database Lookup (Lookup Specification) without leaving a redirect

2024-10-04T20:28:16Z

Dgreenwood moved page 2023:Database Lookup (Lookup) to 2023:Database Lookup (Lookup Specification) without leaving a redirect

← Older revision	Revision as of 15:28, 4 October 2024
(No difference)

Randallkinard at 16:01, 26 August 2024

2024-08-26T16:01:58Z

@@ Line 10: / Line 10: @@
 <blockquote>{{#lst:Glossary|Database Lookup}}</blockquote>
 == About ==
@@ Line 91: / Line 80: @@
 [[File:2023-Database Lookup - Configure the Database Connection 05.png]]
 <section end="how to create a data connection" />

Randallkinard at 18:11, 8 May 2024

2024-05-08T18:11:51Z

← Older revision		Revision as of 13:11, 8 May 2024
Line 10:		Line 10:

	<blockquote>{{#lst:Glossary\|Database Lookup}}</blockquote>		<blockquote>{{#lst:Glossary\|Database Lookup}}</blockquote>

			== Glossary ==
			<u><big>'''Data Connection'''</big></u>: {{#lst:Glossary\|Data Connection}}

			<u><big>'''Data Field'''</big></u>: {{#lst:Glossary\|Data Field}}

			<u><big>'''Data Model'''</big></u>: {{#lst:Glossary\|Data Model}}

			<u><big>'''Database Lookup'''</big></u>: {{#lst:Glossary\|Database Lookup}}

			<u><big>'''Lookup'''</big></u>: {{#lst:Glossary\|Lookup}}

	== About ==		== About ==

Randallkinard at 15:59, 29 April 2024

2024-04-29T15:59:23Z

← Older revision		Revision as of 10:59, 29 April 2024
Line 8:		Line 8:
	This tag will be removed upon draft completion.		This tag will be removed upon draft completion.
	\|}		\|}
	~~<section begin="glossary" />~~
	<blockquote>		<blockquote>{{#lst:Glossary\|Database Lookup}}</blockquote>
	Database ~~Lookups are used to populate or validate fields in a Data Model using an external database, such as a SQL database.~~
	</blockquote>
	~~<section end="glossary" />~~
	== About ==		== About ==

	For validation, values in a '''Data Field''' are compared to corresponding values in a database table. If the results differ from what is in the table, that field can be flagged.		For validation, values in a '''Data Field''' are compared to corresponding values in a database table. If the results differ from what is in the table, that field can be flagged.
	<br>		<br>

Randallkinard: Randallkinard moved page 2023:Database Lookup to 2023:Database Lookup (Lookup) without leaving a redirect: new naming convention

2024-04-16T20:11:47Z

Randallkinard moved page 2023:Database Lookup to 2023:Database Lookup (Lookup) without leaving a redirect: new naming convention

← Older revision	Revision as of 15:11, 16 April 2024
(No difference)

Randallkinard: removed tables and tabs // via Wikitext Extension for VSCode

2024-03-21T17:59:37Z

removed tables and tabs // via Wikitext Extension for VSCode

Dgreenwood at 16:14, 12 January 2024

2024-01-12T16:14:03Z

← Older revision		Revision as of 11:14, 12 January 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	{\|~~cellpadding=10 cellspacing=5 style~~="~~margin:12px~~"		{\|class="wip-box"
	\|~~-style="background-color:#ed2330; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''WIP'''		'''WIP'''
	\|		\|
	This article is a work-in-progress or created as a placeholder for testing purposes. This article is subject to change and/or expansion. It may be incomplete, inaccurate, or stop abruptly.		This article is a work-in-progress or created as a placeholder for testing purposes. This article is subject to change and/or expansion. It may be incomplete, inaccurate, or stop abruptly.

Dgreenwood at 18:18, 9 January 2024

2024-01-09T18:18:39Z

← Older revision		Revision as of 13:18, 9 January 2024
Line 8:		Line 8:
	This tag will be removed upon draft completion.		This tag will be removed upon draft completion.
	\|}		\|}
	<section begin="~~database_lookup_glossary~~" />		<section begin="glossary" />
	<blockquote>		<blockquote>
	Database Lookups are used to populate or validate fields in a Data Model using an external database, such as a SQL database.		Database Lookups are used to populate or validate fields in a Data Model using an external database, such as a SQL database.
	</blockquote>		</blockquote>
	<section end="~~database_lookup_glossary~~" />		<section end="glossary" />
	== About ==		== About ==

Dgreenwood at 20:27, 5 January 2024

2024-01-05T20:27:12Z

← Older revision		Revision as of 15:27, 5 January 2024
Line 8:		Line 8:
	This tag will be removed upon draft completion.		This tag will be removed upon draft completion.
	\|}		\|}
			<section begin="database_lookup_glossary" />
	<~~blockquote style~~="~~font-size:125%~~">		<blockquote>
	Database Lookups are used to populate or validate fields in a Data Model using an external database, such as a SQL database.		Database Lookups are used to populate or validate fields in a Data Model using an external database, such as a SQL database.
	</blockquote>		</blockquote>
			<section end="database_lookup_glossary" />
	== About ==		== About ==

← Older revision		Revision as of 12:59, 21 March 2024
Line 35:		Line 35:

	== How To ==		== How To ==

	=== Create a Data Connection ===		=== Create a Data Connection ===

	Before you can perform a '''''Database Lookup''''', first Grooper must be able to connect to it in order to see everything in the data table. This is done by creating a '''Data Connection'''. Grooper can connect to a SQL database or an ODBC compliant database provider (such as Oracle, MySQL, PostgreSQL, or Db2). You will also need the user name and password used to access the database.		Before you can perform a '''''Database Lookup''''', first Grooper must be able to connect to it in order to see everything in the data table. This is done by creating a '''Data Connection'''. Grooper can connect to a SQL database or an ODBC compliant database provider (such as Oracle, MySQL, PostgreSQL, or Db2). You will also need the user name and password used to access the database.

	<section begin="how to create a data connection" />		<section begin="how to create a data connection" />
	~~<tabs>~~		==== Add a Data Connection ====
	~~<tab name~~="Add a Data Connection">
	~~{\|class~~=~~"how-to-table"~~
	\|
	# In the node tree inside of your project, right click the folder where you would like to create your '''Data Connection'''.		# In the node tree inside of your project, right click the folder where you would like to create your '''Data Connection'''.
	# Hover your mouse over "Add".		# Hover your mouse over "Add".
	# Select "Data Connection..." from the list that pops up.		# Select "Data Connection..." from the list that pops up.
	\|
	[[File:2023-Database Lookup - Add a Data Connection 01.png]]		[[File:2023-Database Lookup - Add a Data Connection 01.png]]
	\|-
	\|
	#<li value=4> When the "Add" window pops up, enter a name for your Data Connection.		#<li value=4> When the "Add" window pops up, enter a name for your Data Connection.
	# Click "EXECUTE" to create.		# Click "EXECUTE" to create.
	\|
	[[File:2023-Database Lookup - Add a Data Connection 02.png]]		[[File:2023-Database Lookup - Add a Data Connection 02.png]]
	\|}
	~~</tab>~~		==== Configure the Database Connection ====
	~~<tab name~~="Configure the Database Connection">
	~~{\|class~~=~~"how-to-table"~~
	\|
	# Select the '''Data Connection''' in your node tree.		# Select the '''Data Connection''' in your node tree.
	# Click the hamburger menu to the right of the '''''Connection Settings''''' property.		# Click the hamburger menu to the right of the '''''Connection Settings''''' property.
	# Select ''ODBC'' or ''SQL Server:-'' from the drop down list. For this example we are going to select ''SQL Server:-''.		# Select ''ODBC'' or ''SQL Server:-'' from the drop down list. For this example we are going to select ''SQL Server:-''.
	\|
	[[File:2023-Database Lookup - Configure the Database Connection 01.png]]		[[File:2023-Database Lookup - Configure the Database Connection 01.png]]
	\|-
	\|
	#<li value=4> Click the arrow next to the '''''Connection Settings Property''''' to open up its sub properties.		#<li value=4> Click the arrow next to the '''''Connection Settings Property''''' to open up its sub properties.
	# Enter in the name of the server hosting the ODBC or SQL.		# Enter in the name of the server hosting the ODBC or SQL.
	# Click the ellipsis button next to the '''''Database Name''''' property.		# Click the ellipsis button next to the '''''Database Name''''' property.
	\|
	[[File:2023-Database Lookup - Configure the Database Connection 02.png]]		[[File:2023-Database Lookup - Configure the Database Connection 02.png]]
	\|-
	\|
	#<li value=7> When the "Database Name" window pops up, scroll through and select the desired database.		#<li value=7> When the "Database Name" window pops up, scroll through and select the desired database.
	# Click "OK" to select.		# Click "OK" to select.
	\|
	[[File:2023-Database Lookup - Configure the Database Connection 03.png]]		[[File:2023-Database Lookup - Configure the Database Connection 03.png]]
	\|-
	\|
	#<li value=9> Enter in the '''''User Name''''' and '''''Password''''' you will be using to access the database. If you leave these fields blank, Grooper will default to Windows Authentication.		#<li value=9> Enter in the '''''User Name''''' and '''''Password''''' you will be using to access the database. If you leave these fields blank, Grooper will default to Windows Authentication.
	# Click the Save icon to save your changes.		# Click the Save icon to save your changes.
	\|
	[[File:2023-Database Lookup - Configure the Database Connection 04.png]]		[[File:2023-Database Lookup - Configure the Database Connection 04.png]]
	\|-
	\|
	#<li value=11> Click the play button to verify your connection. You should see your database information pop up in the other windows.		#<li value=11> Click the play button to verify your connection. You should see your database information pop up in the other windows.
	\|
	[[File:2023-Database Lookup - Configure the Database Connection 05.png]]		[[File:2023-Database Lookup - Configure the Database Connection 05.png]]
	\|}
	~~</tab>~~
	~~:[[#Create a Data Connection\|Click here to return to the top]]~~
	~~</tabs>~~
	<section end="how to create a data connection" />		<section end="how to create a data connection" />