Skip to main content

​
Connecting to iSolved

iSolved is a cloud-based Human Capital Management (HCM) software that unites payroll, benefits, learning management, workforce management, talent acquisition, and core human resources activities. It simplifies management tasks and unifies data to reduce errors and increase productivity. You can connect the iSolved to skyData Studio and perform various tasks such as data ingestion, unification, transformation, and enrichment to gain insights from the data. You can use SkyPoint AI’s built-in connector for importing data from iSolved. This document will guide you through the process of connecting iSolved to the skyData.

​
Prerequisite

You will need the following details to configure and import data using the iSolved⇗ connector:
  • Client Id
  • Legal Ids
  • Key
  • ApiSecret

​
To import data using the iSolved connector

Follow the below steps to create and configure a new dataflow for the iSolved import connector:
  1. Go to Dataflow > Imports.
  2. Click New dataflow.
The Set dataflow name page appears. Alt image
  1. Enter the dataflow name in the Name text area.
  2. Click Next.
The Choose connector page appears. Alt image

​
Add iSolved connector

  1. In the Choose connector page, select iSolved connector. You can use the Search feature to find the connector. Also, the iSolved connector can be found under the Services and apps category.
Alt image
  1. Enter the Display Name for your dataflow in the text area.
  2. You can add a Description in the text area.
  3. Click Next.
The Configuration page appears. Alt image

​
Connect to the iSolved account

Log in to your iSolved account using your username and password. If you do not have an account, you can create one by visiting the iSolved⇗ website.
  1. Enter Client Id the unique identifier assigned to your application.
  2. Enter the Legal Ids to manage data associated with the legal entity, such as payroll, benefits, and other tax and legal-related information.
  3. Enter the Key to identify and authenticate a user.
  4. Enter the ApiSecret to authenticate a user or service when making requests to a web service.
  5. Select the Default Activity Start Date to set the starting date for a new activity.
  6. Click Connect.
Once the connection is established, you can use the connector to import data from a table in iSolved. Alt image
  1. In the Table details section, click the checkbox for the tables you wish to import, then use the dropdown to mark them as either Data or Metadata.

In the Table Details section, all tables are selected by default. You can select the tables you want to import and process. For example, to import customer data, choose the tables that contain customer information, such as name, email, address, and contact details.
  1. Click Save to apply the changes.
After saving the connection, the iSolved connector appears on the Dataflow > Imports page.

​
Run, edit, and delete the imported data

Once the table is imported, you can execute, modify, and remove the imported table from the Dataflow. Follow the below steps:
  1. Go to the Dataflow > Imports page.
Alt image
  1. Select the horizontal ellipsis under the Actions column and do the following:

You can view the error message related to data import failures from a data source in the Dataflow under Run History > Description. Additionally, you can check the status, start time, and end time for the execution of the data pipeline.

​
Next step

After completing the data import, start the Master Data Management (MDM) - Resolve process to create a single, unified view of the data. With Skypoint MDM, you can ensure that your data is accurate, consistent, and reliable, making it easier to use for business processes, analytics, and reporting.