SSIS:Installation: Difference between revisions

Latest revision as of 01:48, 7 January 2023

SSIS Navigation

Quick Start
SSIS Installation
Subscribe

The Data Quality Components for SSIS can either be installed fully on-premise or as a web only install. The following sections will detail the install size, delivery method, data required, and install procedure.

Full On-Premise Install

Size: ~7GB
Deliverable: Physical Disk or Downloadable Zip File (DQC-SSIS_YYYYMM.zip)
Data: Installs all necessary data files for components that have an option for On-Premise Mode.

Component	Mode
Contact Verify	Both (Web and Local)
IP Locator	Both (Web and Local)
Global Verify	Web Only
Personator	Web Only
Smart Mover	Web Only
Property	Web Only
MatchUp	Local Only
Fuzzy Match	Local Only
Profiler	Local Only

Web Only Install

Size: ~150MB
Deliverable: Download Only (setup-web.exe)
Data: Installs only the minimum set of required data files.

Component	Mode
Contact Verify	Web Only (Local not Available)
IP Locator	Web Only (Local not Available)
Global Verify	Web Only
Personator	Web Only
Smart Mover	Web Only
Property	Web Only
MatchUp	Local Only
Fuzzy Match	Local Only
Profiler	Local Only

Install Procedure

To install, download and run the Data Quality Components Executable.

License Agreement

1. Read and accept the license agreement.

Click Next to continue.

License Information

2. Enter your License Key, or continue with the install and enter your License Key later.

Component Selection

3. Select which components to install.

Click Next to continue.

Review

4. Review your installation settings and ensure that everything is as you want it.

Click Install to continue.

Install

5. Wait for the components to install.

Finish

6. Once the Data Quality Components are done installing, you will be prompted to finish the setup.

Click Finish to exit Setup.

You are now ready to start using the Data Quality Components for SSIS.

Basics

How to Open SSIS

1. To open SSIS please find the version of SQL Server and open SQL Server Data Tools.

Start New Project

2. Once SSIS loads, Select New Project. Then under Business Intelligence, select integration services and start a new integration services project.

Data Flow Tab

3. Our components are installed in the data flow SSIS toolbox. You will need to add a data flow task in order to view the toolbox and our components. Otherwise you will not be able to see the correct toolbox in which our components are located in. Our components are only visible in Data Flow Tab.

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISIntroNav
+|QuickStartCollapse=
+}}
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+{{CustomTOC}}
-! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''SSIS Navigation'''
-|-
+The Data Quality Components for SSIS can either be installed fully on-premise or as a web only install. The following sections will detail the install size, delivery method, data required, and install procedure.
-| style="padding-right:220px;"|
+==Full On-Premise Install==
+;Size:~7GB
+;Deliverable:Physical Disk or Downloadable Zip File (DQC-SSIS_YYYYMM.zip)
+;Data:Installs all necessary data files for components that have an option for '''On-Premise Mode'''.
+:{|class="alternate01" cellspacing="0"
+!Component
+!style="border-right:0px;"|Mode
 |-
-|[[SSIS:Introduction|Introduction]]
+|Contact Verify
+|Both (Web and Local)
 |-
-|[[SSIS:System Requirements|System Requirements]]
+|IP Locator
+|Both (Web and Local)
 |-
-|
+|Global Verify
-{| class="mw-collapsible" style="width:100%;"
+|Web Only
-|- align="left"
-! style="color:black;"|Quick Start
 |-
-|[[SSIS:Installation|Installation]]
+|Personator
+|Web Only
 |-
-|[[SSIS:Quick Start|Quick Start]]
+|Smart Mover
+|Web Only
 |-
-|[[SSIS:Licensing|Licensing]]
+|Property
+|Web Only
 |-
-|[[SSIS:Upgrading|Upgrading]]
+|MatchUp
+|Local Only
+|-
+|Fuzzy Match
+|Local Only
+|-
+|Profiler
+|Local Only
 |}
+==Web Only Install==
+;Size:~150MB
+;Deliverable:Download Only (setup-web.exe)
+;Data:Installs only the minimum set of required data files.
+:{|class="alternate01" cellspacing="0"
+!Component
+!style="border-right:0px;"|Mode
+|-
+|Contact Verify
+|Web Only (Local not Available)
+|-
+|IP Locator
+|Web Only (Local not Available)
+|-
+|Global Verify
+|Web Only
+|-
+|Personator
+|Web Only
+|-
+|Smart Mover
+|Web Only
+|-
+|Property
+|Web Only
+|-
+|MatchUp
+|Local Only
+|-
+|Fuzzy Match
+|Local Only
+|-
+|Profiler
+|Local Only
 |}
+==Install Procedure==
+To install, download and run the Data Quality Components Executable.
+===License Agreement===
+. Read and accept the license agreement.
+[[File:SSIS_Install_Agreement.png|link=]]
+Click '''Next''' to continue.
+===License Information===
+. Enter your License Key, or continue with the install and enter your License Key later.
+[[File:SSIS_Install_License.png|link=]]
+===Component Selection===
+. Select which components to install.
+[[File:SSIS_Install_Components.png|link=]]
+Click '''Next''' to continue.
+===Review===
+. Review your installation settings and ensure that everything is as you want it.
+[[File:SSIS_Install_Review.png|link=]]
+Click '''Install''' to continue.
-{{CustomTOC}}
+===Install===
+. Wait for the components to install.
-To install, download and run the Data Quality Components Executable.
+[[File:SSIS_Install_Progress.png|link=]]
-[[File:SSIS_Install_Welcome.png|link=]]
+===Finish===
+. Once the Data Quality Components are done installing, you will be prompted to finish the setup.
-Follow the on-screen prompts to install the components.
+[[File:SSIS_Install_Finish.png|link=]]
-[[File:SSIS_Install_Location.png|link=]]
+Click '''Finish''' to exit Setup.
 You are now ready to start using the Data Quality Components for SSIS.
+==Basics==
+===How to Open SSIS===
+. To open SSIS please find the version of SQL Server and open SQL Server Data Tools.
+[[File:SSIS_NewProject_Open.png|link=]]
+===Start New Project===
+. Once SSIS loads, Select New Project. Then under Business Intelligence, select integration services and start a new integration services project.
+[[File:SSIS_NewProject_01.png|link=]]
+[[File:SSIS_NewProject_02.png|link=]]
+===Data Flow Tab===
+. Our components are installed in the data flow SSIS toolbox. You will need to add a data flow task in order to view the toolbox and our components.
+Otherwise you will not be able to see the correct toolbox in which our components are located in. Our components are only visible in Data Flow Tab.
+[[File:SSIS_NewProject_DataFlow.png|link=]]
 [[Category:SSIS]]

SSIS:Installation: Difference between revisions

Latest revision as of 01:48, 7 January 2023

Contents

Full On-Premise Install

Web Only Install