Contact Zone:MySQL Input - Revision history

Admin at 00:46, 3 January 2017

2017-01-03T00:46:30Z

@@ Line 1: / Line 1: @@
-[[Contact Zone:Reference|&larr; Contact Zone Reference]]
+{{ContactZoneBasicsNav
+|InputCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}

Admin at 20:23, 14 August 2014

2014-08-14T20:23:02Z

← Older revision		Revision as of 20:23, 14 August 2014
Line 51:		Line 51:
	\|[[Contact Zone:Text Output\|Text Output]]		\|[[Contact Zone:Text Output\|Text Output]]
	\|}		\|}
	\|-
	~~\|\|[[Contact Zone:Reporting\|Reporting]]~~
	\|}		\|}

Admin at 17:59, 2 July 2014

2014-07-02T17:59:49Z

← Older revision		Revision as of 17:59, 2 July 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
	! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Contact ~~Verify~~ Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''Contact Zone Basics Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|

Admin at 22:38, 19 June 2014

2014-06-19T22:38:53Z

← Older revision		Revision as of 22:38, 19 June 2014
Line 15:		Line 15:
	! style="color:black;"\|Input		! style="color:black;"\|Input
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Excel Input\|Excel Input]]		\|[[Contact Zone:Excel Input\|Excel Input]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:CSV Input\|CSV Input]]		\|[[Contact Zone:CSV Input\|CSV Input]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:MySQL Input\|MySQL Input]]		\|[[Contact Zone:MySQL Input\|MySQL Input]]
	\|}		\|}
	\|-		\|-
Line 47:		Line 47:
	! style="color:black;"\|Output		! style="color:black;"\|Output
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Excel Output\|Excel Output]]		\|[[Contact Zone:Excel Output\|Excel Output]]
	\|-		\|-
	\|[[Contact Zone~~:Basics~~:Text Output\|Text Output]]		\|[[Contact Zone:Text Output\|Text Output]]
	\|}		\|}
	\|-		\|-
	\|\|[[Contact Zone~~:Basics~~:Reporting\|Reporting]]		\|\|[[Contact Zone:Reporting\|Reporting]]
	\|}		\|}

Admin: Admin moved page Contact Zone:Basics:MySQL Input to Contact Zone:MySQL Input without leaving a redirect

2014-06-19T22:37:01Z

Admin moved page Contact Zone:Basics:MySQL Input to Contact Zone:MySQL Input without leaving a redirect

← Older revision	Revision as of 22:37, 19 June 2014
(No difference)

Admin: Created page with "← Contact Zone Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; c..."

2014-06-19T22:33:51Z

Created page with "← Contact Zone Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; c..."

New page

[[Contact Zone:Reference|← Contact Zone Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Contact Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Contact Zone:Basics|Overview]]
|-
|[[Contact Zone:Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Input
|-
|[[Contact Zone:Basics:Excel Input|Excel Input]]
|-
|[[Contact Zone:Basics:CSV Input|CSV Input]]
|-
|[[Contact Zone:Basics:MySQL Input|MySQL Input]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|MD Components
|-
|[[Contact Zone:Contact Verify|Contact Verify]]
|-
|[[Contact Zone:Global Verify|Global Verify]]
|-
|[[Contact Zone:IP Locator|IP Locator]]
|-
|[[Contact Zone:MatchUp|MatchUp]]
|-
|[[Contact Zone:Personator|Personator]]
|-
|[[Contact Zone:Presort|Presort]]
|-
|[[Contact Zone:SmartMover|SmartMover]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Output
|-
|[[Contact Zone:Basics:Excel Output|Excel Output]]
|-
|[[Contact Zone:Basics:Text Output|Text Output]]
|}
|-
||[[Contact Zone:Basics:Reporting|Reporting]]
|}

{{CustomTOC}}

MySQL is a relational database management system. With input from a MySQL database you can import a variety of data into a tranformation. Contact Zone can use MySQL databases as input.

First you need to setup a Table Input Step.

This step is located in the View/Design Pane, under the Design tab, in the Input folder, with the name Table input.

[[File:CZ_MySQLInput_Workspace.png|link=]]

To get started, Left-click drag and drop the Table input from the View/Design Pane to the Transformation Pane.

==Configuring the Step==
1. Double-click the Table input Step. (Or right-click the Step and select Edit step.)

2. Here the configuration window that belongs to this type of Step will appear. In this case, the Table Input window. Click New....

[[File:CZ_MySQLInput_Table.png|link=]]

3. Now the Database Connection window will open. Here you will setup your MySQL information:

*Connection Name: - Specify a name for your connection.
*Connection Type: - Specify what type connection. In this case, MySQL.
*Access: - Defaults to Native (JDBC).

The following Settings are highly dependent on your MySQL server settings. Contact your network admin to find them out.

*Host Name: - Enter the host name.
*Database Name: - Enter the database name.
*Port Number: - Defaults to 3306.
*User Name: - Enter the user name.
*Password: - Enter the password.
*Database Name: - Enter the database name.

[[File:CZ_MySQLInput_Connection.png|link=]]

4. Click Test.

5. Once the test verifies a connection to the server, click OK.

[[File:CZ_MySQLInput_ConnectionTest.png|link=]]

6. Click OK in the Database Connection Window to finish the database connection setup.

7. In the Table Input Window, select the connection you just set up in the Connection drop-down menu.

8. Click Get SQL Select Statement... and navigate to a desired table in the Database Explorer window. Click OK.

[[File:CZ_MySQLInput_Explorer.png|link=]]

9. A prompt will ask if you want to include the field-names in the SQL. Click Yes.

[[File:CZ_MySQLInput_Include.png|link=]]

10. An SQL query will be generated from the table under the SQL section in the Table Input Window.

11. Click OK to finish defining the MySQL Input Step (through the use of a Table Input).

[[Category:Contact Zone]]