Get Started with Integration Studio Designer

Get Started with Integration Studio Designer

Integration Studio Designer (Powered by Informatica)

UKG's Integration Studio Designer provides access to Informatica Cloud, a cloud-based application partner designed by an industry leader in integrations and a valued UKG technology partner. Through the use of Informatica Cloud, you can integrate key UKG Pro data with other third-party systems.

Integration Studio Dashboard

Login credentials including a user name and password are required for you to access Informatica Cloud via the Studio Designer tile on the Integration Studio page. If you require more than one user name and password, please indicate that on your request. Follow the procedures below to obtain login credentials:

  • Submit a support case requesting login credentials. Your support team will process the request and contact you with the requested login credentials. Informatica Cloud Login Page

    Once you have your Informatica Cloud login credentials, here is a summary of the prerequisite tasks that you need to complete before you create your first export using Informatica Cloud:

  • Install and configure the Informatica Cloud Secure Agent on your organization’s server or another highly available machine.
  • Create a Service Account from UKG Pro (Menu > Administration > Integration Studio > Integration Studio Dashboard > Service Accounts graphic tile).
  • Note the Customer API and User API keys from UKG Pro (Menu > System Configuration > Security > Service Account Administration) for later use in Informatica Cloud.
  • Create a connection from UKG Pro to Informatica Cloud using the UKG Pro (UKG) connector.
  • Create additional Informatica Cloud users for those in your company who need Informatica Cloud access, as needed.
  • Access Cloud Academy and other Informatica Cloud resources to learn more about the Informatica Cloud features you can use to create integrations (recommended).
Important

A connector specifies the source or target for an integration. Through UKG, you can use up to ten different connectors in Informatica Cloud to configure your integrations (for example, UKG Pro (UKG), Salesforce, SQL Server, flat file).

You can view all Informatica Cloud supported connectors here: https://www.informatica.com/products/cloud-integration/connectivity/connectors.html#fbid=Isjvq3JYnOX.

If a supported connector is not available for selection when creating your connections, submit a support case through the UKG Community. In the case, indicate which connector is needed.

Install and Configure the Secure Agent

The secure agent is the engine that moves data between sources and targets. This lightweight, self-upgrading application runs behind your firewall and processes the integrations on your network.

It basically provides the communication to Informatica Cloud from your local machine (or server). It is important to note that the Informatica Secure Agent provides secure access to your data sources and never uploads your data to the Informatica Cloud servers. This is shown in this Informatica diagram (Informatica, 2015). The UKG Pro database is indicated in the Local Files and/or Databases section.

Informatica Cloud Secure Agent Diagram

You can install the Secure Agent from your local machine or you can choose to run this from a server. It is best that you install this on a machine that is always running, such as a server.

  1. Log in to Informatica Cloud Services from the destination machine.
  2. From the Administrator page, select Runtime Environments.
  3. Select Download Secure Agent. The Download Agent pop-up window appears.
  4. Select your platform (Windows or Linux) and then select Download.
  5. When the Download is complete, install the agent by running the agent_install.exe file.
  6. Follow the onscreen prompts to complete the installation.
  7. Near the end of the installation process, a prompt to register the secure agent appears.
  8. Enter your Informatica Cloud Services login credentials (user name and password).
  9. When the installation is complete, the agent appears on the Runtime Environments page in an Active status.
    Secure Agent with an Up and Running Status
    Note

    If the Secure Agent is not listed or is in an inactive status, there may be a communications problem between the Agent and the Informatica Cloud Services. For Secure Agent troubleshooting tips, check the Informatica Cloud Services online help or visit the Informatica Community site.

Informatica Cloud Secure Agent Requirements

To install the secure agent, minimum system requirements must be met.

Follow these minimum system requirements to install the Informatica Cloud Secure Agent.

Hardware:

  • 2-4 CPU recommended
  • 2 GB RAM recommended dedicated for the Agent (Recent customers have used 8GB.)
  • 1 GB Hard disk space
  • 1 GB Network connectivity (The faster the better as this will most likely be the bottleneck.)

Operating Systems:

  • Windows
    • Windows 7 (32-bit or 64-bit)
    • Windows 2008 R2 (32-bit or 64-bit)
    • Windows 2012 (64-bit)
    • Windows 2012 R2 (64-bit)
  • Linux
    • Linux (32-bit or 64-bit) with the following configuration:
    • Red Hat Enterprise Linux version 6.x and above (32-bit or 64-bit)
    • SuSe Linux Enterprise version 11.0 and above (32-bit or 64-bit)

Disk Space:

  • Minimum disk space required is 500 MB.

Networking:

  • Required Ports
    • 443 (SSL)
  • Optional Ports
    • Using SQL: 1433

IP Addresses:

Select this Informatica Knowledge Base document link to view Informatica IP address information: https://kb.informatica.com/KBExternal/Pages/Home.aspx

Additional Installed Libraries:

  • 64 bit 2010 VC++ libraries should be installed on the windows machine.
  • https://www.microsoft.com/en-in/download/details.aspx?id=14632

Add or Change a Service Account

A service account provides the credentials required to integrate with UKG Pro using Web Services, Report Exports, or Integration Studio Designer.

When using Web Services or Integration Studio Designer, a Service Account is required for each of the Web Services you use.

Add or change a service account from the Add/Change Service Account page. This page is accessible from the Service Account Administration page via two navigation paths:

Navigation:Menu > System Configuration > Security > Service Account Administration

Navigation:Menu > Administration > Integration Studio > Integration Studio Dashboard > Service Accounts graphic tile

  1. From the Service Account Administration page, complete one of the following:
    • To add a service account, select Add. The Add/Change Service Account page appears.
    • To change a service account, select the User Name link for the service account from the list.
  2. From the Add/Change Service Account page, enter a user name for the account. The user name must be unique; it cannot be an existing user account name used to access the portal. We recommend that you add the partner name to the end of the recommended user names as shown in the table below.
  3. Enter an email address for the service account.
  4. The Generate New Password box is automatically selected when adding a new Service Account. After entering the remaining required information and selecting Save, a New Password window displays with the randomly generated password. You can copy the password and save it in a secure location. You will not be able to see this password again after closing the New Password page. If the password is lost or forgotten, a new one will need to be generated.
    Add or Change Service Account for LMS integration
  5. For each Web Service, select which types of methods (Add, Delete, View, and/or Edit) the service account will be able to access.
    Note Granting View access allows access to the Find method (if applicable) and Get methods for a Web Service. Some methods are not available for certain Web Services and cannot be selected.

    For the following integrations, ensure that the minimum access required is selected for the associated service account methods:

    Web Service Integrations
    PartnersService Account Method RequiredRecommended UsernameMinimum Access Required

    * Denotes a Partner Integration that is Coming Soon

    Applicant Tracking System

    Greenhouse

    iCIMS connector Powered by The Cloud Connectors

    Jobvite

    Lever

    Taleo connector Powered by Modulus Data

    • Company Configuration Integration
    • Employee Export
    ApplicantTracking-PartnerNameView Access
    Compensation Data

    PayScale

    • Company Configuration Integration
    • Compensation Details
    • Employee Job History
    • Person Details
    • Personnel Integration
    CompData-PartnerNameView Access
    Compensation Management

    HRSoft

    • Company Configuration Integration
    • Employee Compensation Details
    • Employee Employment Information
    • Employee Job History Details
    • Employee Person Details
    • Employee User-Defined Fields
    • Personnel Integration
    CompManagement-PartnerNameView Access
    Employee Verification
    Note For Equifax customers, refer to the Income and Employment Verification from Equifax Integration job aid in the UKG Community Library for more information.

    Equifax US

    Equifax Canada

    Vault Verify

    • Employee Compensation
    • Employee Pay Statement
    • Employee Phone Information
    • Employee Termination
    • Company Configuration Integration
    • Employee Export
    • Personnel Integration
    • Employee Job History Details
    • Employee Person Details
    • Employee Compensation Details
    EmployeeVerification-PartnerNameView Access
    Expense Management
    Chrome River
    • Company Configuration Integration
    • Employee Direct Deposit
    • Employee Export
    ExpenseManagement-PartnerNameView Access
    Financial Wellness

    Vault

    • Company Configuration Integration
    • Employee Export
    • Personnel Integration
    FinancialWellness-PartnerNameView Access
    Global Payroll

    activpayroll

    CloudPay

    Immedis

    PayAsia

    Groupo Ono*

    • Company Configuration Integration
    • Employee Compensation Details
    • Employee Job History Details
    • Employee Person Details
    • Employee Export
    • Global Employee Direct Deposit
    • Payroll Integration
    • Personnel Integration
    • Third Party Pay Services
    GlobalPayroll-PartnerNameView Access

    Note: The Third Party Pay Services requires: Add, View, Edit, and Delete Access

    Identity Management

    CyberArk

    ManageEngine

    OneLogin

    Ping

    • Company Configuration Integration
    • Employee Person Details
    • Personnel Integration
    • Note: OneLogin also requires Reports-As-A-Service
    IdentityManagement-PartnerNameView Access
    Integration Studio / Informatica
    Integration Studio Informatica
    • Employee Self-Service API
    IntegrationStudioView Access
    Job Posting
    Appcast

    TeamWork Online

    Symphony Talent

    • Reports-As-A-Service
    JobPosting-PartnerNameBusiness Intelligence (BI) Access
    Learning Management System (LMS)

    Cornerstone OnDemand

    • Employee Export (for Employee Changes API)
    • Company Configuration Integration (For Organization Levels, Jobs Configuration and Locations Configuration APIs)
    • Development Opportunity Participation Service
    • Development Opportunity Service
    • Development Opportunity Session Service
    LMSIntegration-PartnerNameView Access

    Note: These services require Add, View, Edit, and Delete Access:

    • Development Opportunity Participation Service
    • Development Opportunity Service
    • Development Opportunity Session Service
    Organization Chart

    Ingentis Softwareentwicklung GmbH

    OrgChart Now by OfficeWork Software

    • Employee Compensation Details
    • Employee Person Details
    • Personnel Details
    OrganizationChartIntegration-PartnerNameView Access
    PayCard
    rapid! PayCard
    • Company Configuration Integration
    • Employee Direct Deposit
    • Employee Person
    • Employee Person Details
    PayCardIntegration-PartnerNameView Access
    Scheduling
    Humanity*
    • Company Configuration Integration
    • Employee Export
    • Personnel Integration
    SchedulingIntegration-PartnerNameView Access
    Social Collaboration

    Planned Companies

    Beekeeper

    • Company Configuration Integration
    • Employee Export
    SocialCollaboration-PartnerNameView Access
    Work Opportunity Tax Credits (WOTC)
    HireCredit
    • Employee Pay Statement Service
    • Personnel Integration
    WOTC_PartnerNameView Access
    Additional Functionality to Support Background Screening
    Additional functionality to support Background Screening
    • Company Configuration Integration
    BackgroundScreening-PartnerNameView Access
  6. Select Save. The Service Account Administration page appears with the new or modified service account.

Locate API Keys

The User API Key and Customer API Key are required to authenticate a call to UKG Pro for integrations using Web Services and Integration Studio Designer.

The User API Key is a unique value assigned to each Service Account. The Customer API Key value is a unique value assigned to each UKG Pro customer.

Navigation:Menu > System Configuration > Security > Service Account Administration

  1. From the Service Account Administration page,
    • locate the value for the Customer API Key
    • locate the User API Key for the applicable service account.
    User API and Customer API Keys
  2. Note the value of the keys for use when configuring Web services or an Informatica Cloud connection.

Create the UKG Pro Connection

Create the UKG Pro connection from the Connections page of Informatica Cloud. The connection is necessary to extract data from UKG Pro and holds the connection information for a specific endpoint.

Important

The Informatica secure agent must be installed on your designated server before you create the UKG Pro connection.

You should also have the following information before beginning this task:

  • Service Account user name and password
  • Customer API Key
  • User API Key associated with the Service Account
  • Location of the installed secure agent

Navigation:Informatica Cloud > Administrator > Connections

  1. From the Connections page, select New Connection. The New Connection page appears.
    • Enter a unique name for the connection in the Connection Name field.
    • Enter an optional description in the Description field, if desired.
    • From the Type drop-down list, select UKG Pro (UKG). The UKG Pro Connection Properties section appears. UKG Pro Connection
  2. From the Runtime Environment drop-down list, select the name of the server where you installed the Informatica Cloud Secure Agent.
  3. At the Password and UKG Pro User Name fields, enter the UKG Pro Service Account password and username.
  4. At the Service Host Name field, enter the service host name. The service host name is your company UKG Pro domain. The format of the domain is service$.ultipro.com, where $ is a numerical value. You can find the service host name in the web service endpoints from the Web Services page in UKG Pro (Menu > System Configuration > Security > Web Services).
    Note

    When you enter the service host name, do not include the "http://" from the endpoint path found on the Web Services page.

  5. At the Customer API Key field, enter your customer API key.
  6. At the User API Key, enter your user API key. (Be sure to enter the User API key associated with the Service Account.)
  7. From the Application Module drop-down list, select the applicable application module. For most general UKG Pro integrations, select HR, Payroll, Talent, Benefits.
    UKG iPro Connection with Configured Properties
    Note

    The application modules are explained as follows:

    • The HR, Payroll, Talent, Benefits application module is used to extract HR, Payroll, Talent, and Benefits data, including integrations triggered by an Integration Event.
    • The Integration Events application module is only used to extract a list of completed UKG Pro Events on-demand.
    • The Other application module is used for Time Management integrations.
  8. Select Test to test the new connection for UKG Pro. A status message appears to let you know if the connection is valid.
    Note

    Verify that the secure agent is active and running before you test the connection.

  9. Select Save to save the new connection.

Informatica Cloud User Administration

When UKG provides your company access to Informatica Cloud, your first Informatica Cloud user is configured as an administrative user. This administrative user has the ability to create and administer accounts for any of your company’s additional Informatica Cloud users.

Administrator - Users, User Groups, and User Roles

All user, user groups, and user roles administration is completed on the Users page (Administrator > Users), User Groups page (Administrator > User Groups), User Roles page (Administrator > User Roles).To learn how to configure users, user groups, and user roles in Informatica Cloud, access Informatica Cloud’s Administrator Guide located in their Online Help.

Important

If an admin<#>@ultimatesoftware.com user appears in the Users section, that is the service account used by UKG for Integration Events. Do not modify this account’s details or password. Doing so will result in errors in your integrations.

Additionally, if you choose to create user groups to manage your Informatica Cloud users, every user must be assigned to a user group. Therefore, you must create an Admin user group with all permissions enabled for the admin<#>@ultimatesoftware.com account.

Informatica Cloud Resources

Informatica Cloud provides many resources to help you learn how to use their powerful tool set to create your UKG Pro integrations.

ResourceDescriptionAddress
Cloud AcademyAccess many Informatica Cloud learning opportunitieshttps://www.informatica.com/services-and-training/informatica-university.html
Cloud Data Integration CommunityFollow, share, and participate in the Informatica Cloud Data Integration communityhttps://network.informatica.com/community/informatica-network/products/cloud-integration/cloud_data_integration/
Informatica Knowledge Base Access the Informatica Expert Assistant, access knowledge base articles, and view Support TV videoshttps://kb.informatica.com/KBExternal/Pages/Home.aspx