WIXLIB

Message queue client software: If you want Connect to access data in a message queue, thenthe appropriate message queue client software must be on the system and accessible via theappropriate shared library or dynamic link library (dll) paths. For example, to access an IBMWebSphere MQ queue, IBM WebSphere MQ client must be installed on the system where yourun Connect. For details on how to connect to a specific message queue type, refer to the sectionConnecting to Message Queues from Connect. SAP client software: If you want Connect to access data in an SAP system, then the appropriateSAP client software must be installed on the system where you run Connect and accessible viathe appropriate shared library or dynamic link library (dll) paths. For details on how to connect toan SAP system, refer to the section Connecting to SAP from Connect. Hadoop software: If you want Connect to access data in a Hadoop Distributed File System (HDFS),or you want to run Connect for Big Data ETL MapReduce jobs, then a Hadoop distribution configuredto access the cluster must be installed on the edge/ETL node from which you run Connect. Fordetails on how to connect to HDFS, refer to the section Connecting to HDFS from Connect. Connect:Direct software: If you want Connect to access data using a Connect:Direct connection,a Connect:Direct server and client (CLI/API) must be installed on the system where you run Connectand must be configured to access the required Connect:Direct nodes. For details on how to connectto a Connect:Direct node, refer to Connecting to Connect:Direct nodes from Connect. QlikView software: Connect supports QlikView data eXchange (QVX) files as targets. To accessQVX files as sources from QlikView or Qlik Sense, refer to Connecting to QlikView dataeXchange files from QlikView or Qlik Sense. Tableau software: Connect supports Tableau Data Extract (TDE) files as targets. To access TDEfiles as sources from Tableau, refer to Connecting to Tableau Data Extract files from Tableau.Connect installation user setup considerationsThe type of user required for your setup depends on whether you extend impersonation privileges: If you plan to use impersonation when running the Editor Runtime Service, dmxd, you must installas root. When running the Connect Portal Copy Runtime Service, dmxrund, considerations exist for thetype of user that installs components.User setup when running dmxrundIf you do not plan to use impersonation when running dmxrund, setup a non-administrative user toinstall and run on Windows or setup a service user to install and run on Linux.As the administrative user has impersonation privileges by default, setup a new user who does nothave administrative rights.Connect 9.13.1 Installation Guide10

Setup a non-administrative/service user for WindowsAs the administrative user has impersonation privileges by default, setup a new user who does nothave administrative rights.Setup a non-administrative/service user for LinuxTo install and run job requests without impersonation, create a service user, such as connectuser,and run the installation as connectuser.Setup impersonationIf you plan to use impersonation when running dmxrund, setup an impersonated user to install andrun on Linux.WindowsAs the administrative user has impersonation privileges by default, no setup is required.LinuxConnect installation impersonation considerations on Linux follow: No impersonation: Running jobs without impersonation does not require root access. Upon receiptof a job submission request from the dmxrund calls the Connect Engine, dmxdfnl, to run thesubmitted job as the service user, connectuser. Impersonation: Running jobs with impersonation requires root access to impersonate the specifieduser. While dmxrund never is granted root access, another installed component, dmxexecutor, canenable impersonation. When dmxrund detects that dmxexecutor is installed in the required directorywith the correct permissions, dmxrund calls dmxexecutor to impersonate the specific user that callsthe Connect engine, dmxdfnl, which runs the submitted jobs.To install and run job requests with impersonation, do the following: Create a service user, such as connectuser. Create a service group, dmexpress.Note: If you choose to change the name of the service group, you must update theSERVICE GROUP property of the Connect custom impersonation configurationproperties file. Add connectuser to the dmexpress service group. Run the installation as connectuser. Ensure that the following files are in the specified directories with the specified permissions:Connect 9.13.1 Installation Guide11

Directory and filePermissionsNotes Connect installation /bin/ -rwsr-x--dmxexecutorThe ‘s’ represents the set-user identification (setuid) bit and indicatesthat dmxexecutor is extended impersonation privileges to run submittedjobs as a specific user. Connect installation /conf/ -rwx-----dmxexecutor.confUpdates to dmxexecutor.conf are required only if you choose to customizethe impersonation.Setup Connect License InformationTo obtain a license key, you need the computer name, the hardware model, the number of processors,and the operating system of each system on which Connect is to run. You can gather the systeminformation by running the Connect License Information program.Windows SystemsYou can run the Connect License Information program in the following ways: From Precisely’s web site xe If Connect is installed, go to Programs, Connect from the Start menu and select License Information.The program prepares a license information document with the system information and then displaysit in a Notepad window. You can save the form (File, Save As) and e-mail it to Precisely or to yourlocal Connect sales agent. The information is then used to create your license key(s).UNIX SystemsYou can run the Connect License Information program in the following ways: From Precisely’s web site h If Connect is installed, go to the connect install /bin directory, where connect install denotesthe directory where Connect is installed, and type: ./licenseinfoThe program generates and displays a text file named PreciselyLicenseInfo.txt in the current directory.You can e-mail the file to Precisely or to your local Connect sales agent. The information is thenused to create your license key(s).Connect 9.13.1 Installation Guide12

Step-by-Step InstallationWindows Systems1. Make sure that any previous version of Connect has been removed (see Removing Connectfrom Your System later in this guide if necessary).2. You can also install Connect by running\Windows\x86\setup.exe for 32-bit Windows\Windows\x64\setup.exe for 64-bit Windows x64extracted from the downloaded executable directly or via Control Panel, Add/Remove Programs.3. You are prompted to either enter a license key or start a free trial. If you have selected to entera license key, you can type in the location of the DMExpressLicense.txt, or browse to it, whenprompted. You can also enter the license key manually.4. Read the terms of the Precisely License Agreement and confirm your acceptance of them.5. Review the product options, components and features that are enabled by your license key.6. If your license key is a Connect server license key, a menu displays from which you select from among the componentoptions: StandardFullClassicCustomFor information on these options, see Connect installation component options. Select an optionand make the appropriate selections. Connect workstation license key, no component options display for selection.You are eligible for the classic Connect ETL/Connect for Big Data installation, which installs the Joband Task Editors, Job and Task Editors, Connect engine (dmxjob/dmexpress), and the service forJob and Task Editors, Connect Editor Runtime Service, dmxd.Confirm the file folder into which you want to install Connect. The file folder is subsequently referredto as connect install .Select the program folder in which you want the Connect icons to appear.Connect 9.13.1 Installation Guide13

Review the Setup Information, choose back to change these options or install to complete installation.If your license key enables the Editor Runtime Service, select the configuration options for the Service.You can also configure the Editor Runtime Service later via Control Panel, Administrative Tools,Services.You may be prompted to choose whether to automatically run SyncSort jobs in Connect, eitherimmediately or after subsequent un-installation of SyncSort, depending on the presence of theSyncSort Conversion license option and an existing installation of SyncSort.Upon setup completion, a list of menu shortcuts display in the Connect program folder, which isavailable through the Windows Start menu.To run the Connect Portal web UI, you must configure the Connect Portal and ManagementService, DMXManager, including authentication. Then, start the Connect Portal and ManagementService via Control Panel, Administrative Tools, Services.To run copy projects in Connect Portal, start the Connect Portal Copy Runtime Service via ControlPanel, Administrative Tools, Services. See Connect Portal Copy Runtime Service installationand configuration for more details.To run CDC replication projects in Connect Portal, separately install the latest version of ConnectCDC. The Connect CDC Listener service starts automatically when you install Connect CDC, butthe listener service must be running to run CDC replication projects in Connect Portal.If you performed a full install, including the Job and Task Editors, the following menu shortcutsdisplay: Precisely Connect Apply a New License KeyConnect Application UpgradeConnect Global FindConnect HelpConnect Job EditorConnect PortalConnect ServerConnect Task EditorLicense InformationReference GuidesRelease NotesIf you performed a standard or classic install, with the Job and Task Editors but not the ConnectPortal and Management Service, the following menu shortcuts display: Precisely Connect Apply a New License Key Connect Application Upgrade Connect Global FindConnect 9.13.1 Installation Guide14

Connect HelpConnect Job EditorConnect ServerConnect Task EditorLicense InformationReference GuidesRelease NotesIf you installed the Connect Portal and Management Service only (custom install), the following menushortcuts display: Precisely Connect Apply a New License KeyConnect HelpConnect PortalLicense InformationReference GuidesRelease NotesIf you did not install the Job and Task Editors nor the Connect Portal and Management Service, thefollowing menu shortcuts display: Precisely Connect Apply a New License KeyConnect HelpConnect PortalLicense InformationReference GuidesRelease NotesIf you have ActiveX based SyncSort applications which you choose to run with Connect, and yousubsequently uninstall SyncSort, you may need to re-register the SyncSortX ActiveX control. Toregister the ActiveX control, open a command prompt and type the following command:regsvr32.exe connect install /Programs/SyncSortX.dllSilent InstallationSilent installation requires a silent setup file that can be recorded during an interactive installation.Installation steps may differ depending on product licensing, so changing the version of Connect oradding or removing packages may require re-recording the silent setup file.To record the installation optionsConnect 9.13.1 Installation Guide15

Open a command prompt; type the full path for the installation program followed by the options:–r –f1 silent setup file where silent setup file is the full path for the file to record the installation options. If youare installing from a downloaded image which is located in c:\downloads, you would type acommand like:C:\downloads\DMExpress 1-4 windows.exe–r –f1c:\temp\setup.issAn interactive installation starts and all the selected installation options are saved in the specifiedfile.To run the installation in silent modeOpen a command prompt; type the pathname of the install executable followed by the options:–s –f1 silent setup file -slog log file where silent setup file is the full path for the file that was previously used to record theinstallation options, and log file is the full path for the installation log file generated by silentinstallation. If you are installing from a downloaded image which is located inc:\downloads, you would type a command like:C:\downloads\DMExpress 1-4 windows.exe –s–f1c:\temp\setup.issIf you do not specify the –slog option, then setup generates a log of the silent installation, setup.log,in the folder from which the setup is run or in the folder where the specified silent setup file is located.Multiple command line options are separated with a space, but there should be no spaces inside acommand line option (for example, –slogc:\setup.log is valid, but –slog c:\setup.log isnot).Note: When running silent installation on a machine with User Account Control enabled, anadministrator command prompt or batch file can be used to avoid the initial prompt by theoperating system requesting elevated privileges. To start a Command Prompt withadministrative privileges, right-click the Command Prompt shortcut and select "Run asadministrator".UNIX SystemsPrerequisites for COBOL SupportConnect can be used to accelerate COBOL SORT and MERGE verbs or to process COBOL datafiles as source or target. In order to use these features, you must have a license to use the COBOLcompiler on the system where the Connect task runs.Connect 9.13.1 Installation Guide16

Micro Focus COBOL or Server ExpressThe following variables must be set prior to installation: the COBDIR and PATH variables must beset and exported to include the COBOL compiler, and the following environment variable for sharedlibraries must be set to include all the shareable libraries used by the compiler and exported on thecorresponding platform:AIXLIBPATHHP-UXSHLIB PATHLinuxLD LIBRARY PATHSolarisLD LIBRARY PATHAcuCorp’s ACUCOBOL-GT COBOL Development SystemSupport for ACUCOBOL-GT is available on the following UNIX platforms:Operating SystemArchitectureHP-UX64-bit for ItaniumAIX64-bit on PowerPCSunOS64-bit on SPARC processorsThe bit level of Connect must match that of the ACUCOBOL-GT installation.Before running the Connect install script, set the environment variable ACUCOBOL:export ACUCOBOL acucobol install dir where acucobol install dir is the location of your ACUCOBOL-GT installation. If theenvironment variable COBDIR is set, unset it:unset COBDIROnce Connect has been installed, additional steps need to be performed to enable support forAcuCOBOL. Please refer to the Connect online help topic “Installing support for AcuCOBOL.”COBOL-ITSupport for COBOL-IT line sequential files is available on the following UNIX platforms:Connect 9.13.1 Installation Guide17

Operating SystemArchitectureAIX64-bit on PowerPCLinux64-bit for Intel-compatible processorsThe bit level of Connect must match that of the COBOL-IT installation. The minimum supportedCOBOL-IT version is 3.7.Before running the Connect install script, do the following: Unset the environment variable COBDIR, if set:unset COBDIR Set the environment variable COBOLITDIR:export COBOLITDIR cobol-it install dir where cobol-it install dir is the location of your COBOL-IT installation.To configure COBOL-IT runtime environment variables, refer to the Connect online help topic,“Installing support for COBOL-IT.”Informix C-ISAM SupportIf you plan to use Connect to process Informix C-ISAM files, the environment variable INFORMIXDIRmust be set and exported prior to running the install script. The directory INFORMIXDIR/lib mustcontain the library libisam.a.Unikix VSAM SupportIf you plan to use Connect to process Unikix VSAM files, the environment variable UNIKIX must beset and exported prior to running the install script. The directory UNIKIX/lib must contain the librarylibbcisam.a.Interactive InstallationIf you are installing from a tar file that you downloaded from Precisely’s web site, extract the contentsof the tar file on your UNIX system using a command similar to:tar xvof DMEXPRESS.TARThis creates a directory dmexpress under the current directory.Connect 9.13.1 Installation Guide18

Log in as user root if you want to install or configure the Editor Runtime Service. The Editor RuntimeService allows you to submit tasks or jobs from the Connect Task Editor or Job Editor components,running on remote desktops, to execute on this Connect server.To install using downloaded software, navigate to the dmexpress directory created when you extractedthe contents of the tar file and then run the install program. For example,cd /usr/tmp/dmexpress./installDepending on your system and the licensed options, you may be asked several questions. Forexample, on platforms where both a 32-bit and a 64-bit version of Connect are available, you areasked to choose which one you would like to install.You are prompted to either enter a license key or start a free trial. If you have selected to enter alicense key, specify the location of the license key file, DMExpressLicense.txt, when prompted.Read the terms of the Precisely License Agreement and confirm your acceptance of them.Review the product options, components and features that are enabled by your license

HDFS. See the online Connect Help topic "Spark Mainframe Connector". Apache Sqoop Integration - Use the Sqoop mainframe import connector to transfer mainframe data into HDFS. See the online Connect Help topic "Sqoop Mainframe Import Connector". Connect for Big Data Requirements Connect for Big Data requires the following: