SSIS:Global Verify:Email: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."
 
No edit summary
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISGlobalVerifyNav
 
|GlobalVerifyCollapse=
{| 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;"|'''Global Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Global Verify|Overview]]
|-
|[[SSIS:Global Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Global Verify:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Global Verify Tabs
|-
|[[SSIS:Global Verify:Name|Name]]
|-
|[[SSIS:Global Verify:Address|Address]]
|-
|[[SSIS:Global Verify:Phone|Phone]]
|-
|[[SSIS:Global Verify:Email|Email]]
|-
|[[SSIS:Global Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[SSIS:Global Verify:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 75: Line 30:
:The name for the top level domain description output column.
:The name for the top level domain description output column.


;Domain Age Estimated
:The estimated age of the domain in days.
;Domain Expiration Date
:The date the domain expires/expired in the <code>YYYY-MM-DDTHH:MM:SS</code> format.


==Mailbox Verification Options==
;Domain Created Date
;Off
:The date the domain was created in the <code>YYYY-MM-DDTHH:MM:SS</code> format.
:No checking on the mailbox is done.
 
;Domain Updated Date
:The date the domain was last updated in the <code>YYYY-MM-DDTHH:MM:SS</code> format.
 
;Domain Email
:The email associated with the domain.
 
;Domain Organization
:The organization associated with the domain.
 
;Domain Address 1
:The street address associated with the domain.
 
;Domain Locality
:The locality associated with the domain.
 
;Domain Administrative Area
:The administrative area associated with the domain.
 
;Domain Postal Code
:The postal code associated with the domain.
 
;Domain Country
:The country associated with the domain.
 
;Domain Country Code
:The country code associated with the domain.
 
;Domain Availability
:Check to see if domain is available for purchase.
 
;Domain Private Proxy
:Check if domain is behind a private proxy.
 
;Deliverability Confidence Score
:Returns the probability [0-100]% of an email sent to this mailbox will be successfully delivered.
 
;Privacy Flag
:The top level domains or countries that may be sensitive to privacy laws. Returns <code>Y</code> for yes and <code>N</code> for no.
 
;MX Server
:Returns which MX Server was used to validate the email address. Only available in Premium Mode.


;Mixed
:Check the Email Address against the Web Service Email Reference Data. If the Email is not found in the data, run it through real-time Email Verification.


;Fast
==Mailbox Verification Options==
;Express
:Check the Email Address against the Web Service Email Reference Data.
:Check the Email Address against the Web Service Email Reference Data.


;Realtime
;Premium
:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.
:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.
Note: The 'Off' and 'Mixed' options have been deprecated.
==Advanced Email Options==
;Days Since Last Verified
:''Premium Mode Only''
:You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.
;Domain Correction ON/OFF
:Activates fuzzy email domain correction if the domain is a suspected typo.
;Domain Information ON/OFF
:Activates output fields for WhoIS domain information.




[[Category:SSIS]]
[[Category:SSIS]]
[[Category:SSIS Global Verify]]
[[Category:SSIS Global Verify]]

Latest revision as of 19:17, 1 June 2020

← SSIS:Data Quality Components

Global Verify Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
On-Premise
Global Verify Tabs
Name
Address
Phone
Email
Pass-Through Columns
Output Filter
Result Codes
Returned Result Codes
Result Codes



Verify the domain of an email address as well as correct syntax, typos, and update older domain names.

Input Columns

Email Address
Select the field containing the input email address.


Output Columns

Email Address
The name for the email address output column.
Mail Box Name
The name for the mail box output column.
Domain Name
The name for the domain output column.
Top Level Domain
The name for the top level domain output column.
Top Level Domain Description
The name for the top level domain description output column.
Domain Age Estimated
The estimated age of the domain in days.
Domain Expiration Date
The date the domain expires/expired in the YYYY-MM-DDTHH:MM:SS format.
Domain Created Date
The date the domain was created in the YYYY-MM-DDTHH:MM:SS format.
Domain Updated Date
The date the domain was last updated in the YYYY-MM-DDTHH:MM:SS format.
Domain Email
The email associated with the domain.
Domain Organization
The organization associated with the domain.
Domain Address 1
The street address associated with the domain.
Domain Locality
The locality associated with the domain.
Domain Administrative Area
The administrative area associated with the domain.
Domain Postal Code
The postal code associated with the domain.
Domain Country
The country associated with the domain.
Domain Country Code
The country code associated with the domain.
Domain Availability
Check to see if domain is available for purchase.
Domain Private Proxy
Check if domain is behind a private proxy.
Deliverability Confidence Score
Returns the probability [0-100]% of an email sent to this mailbox will be successfully delivered.
Privacy Flag
The top level domains or countries that may be sensitive to privacy laws. Returns Y for yes and N for no.
MX Server
Returns which MX Server was used to validate the email address. Only available in Premium Mode.


Mailbox Verification Options

Express
Check the Email Address against the Web Service Email Reference Data.
Premium
Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

Note: The 'Off' and 'Mixed' options have been deprecated.

Advanced Email Options

Days Since Last Verified
Premium Mode Only
You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.
Domain Correction ON/OFF
Activates fuzzy email domain correction if the domain is a suspected typo.
Domain Information ON/OFF
Activates output fields for WhoIS domain information.
Retrieved from "http://wiki.melissadata.com/index.php?title=SSIS:Global_Verify:Email&oldid=17138"