Skip to main content

​
Connecting to PayNW

Learn how to seamlessly integrate PayNW with skyData, covering setup, configurations, and important factors. PayNW provides cloud-based Human Capital Management (HCM) solutions for mid-sized and growing businesses, streamlining payroll, HR, time tracking, benefits administration, and talent acquisition. Key features include accurate payroll processing, automated compliance, self-service tools for employees, and scalable integrations. Businesses benefit from reduced administrative burdens, improved efficiency, and regulatory compliance, enabling them to focus on strategic growth. The skyData Platform (AIP) seamlessly integrates with PayNW via an inbuilt connector, enabling real-time data synchronization for payroll, HR, time tracking, and benefits while enhancing automation, providing AI-driven insights, ensuring compliance, and offering self-service tools,all within a scalable, future-ready solution designed to minimize manual effort and optimize decision-making.

​
Prerequisite

You need the following details to configure and import data using the PayNW⇗ connector:
  • Server name
  • Database name
  • Port number
  • Username
  • Password

​
To import data using the PayNW connector

Follow the below steps to create and configure a new dataflow for the PayNW import connector:
  1. Navigate to Dataflow > Imports.
Set paynw dataflow on skypoint ai
  1. Click New dataflow as indicated by an arrow.
The Set dataflow name page appears. Key in dataflow name for paynw
  1. Enter the desired name for the dataflow in the Name text field.
  2. Click Next to proceed.
The Choose connector page appears. Search to select paynw connector

​
Add PayNW Server connector

  1. On the Choose Connector page, use the Search feature to locate and select the PayNW Connector.
  2. Enter the Display Name for your dataflow in the provided text field.
  3. Optionally, add a Description in the designated text area.
Key display name for paynw connector dataflow
  1. Click Next to proceed.
The Configuration page appears. Configure paynw connector on Skypoint ai

​
Connect to the PayNW account

  1. Fill in the required details on the Configuration page.
  2. Click Connect.
Connect paynw account on skypoint ai Once the connection is established, the connector can be used to import data from PayNW tables.
  1. Scroll down to the Table Details section, select the checkboxes for the tables you wish to import, and use the dropdown menu to label them as either Data or Metadata.
Select tables to import paynw data into skypoint ai
By default, all tables in the Table Details section are selected. You can choose to import only specific tables that are relevant to your data processing needs. For example, to import customer data, select tables containing details like name, email, address, and contact information.
  1. Ensure all required tables are selected.
  2. Click Save to apply the changes.
Save paynw dataflow on skypoint ai Congratulations! for saving the PayNW connector dataflow, which 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.
Modify paynw dataflow on skypoint ai studio
  1. Select the horizontal ellipsis under the Actions column and do the following:
  1. Click Run to execute the dataflow. Once the execution is successful, the data pipeline status will update to Completed, as illustrated in the figure below.
Data import complete from paynw on skypoint ai
In the Dataflow’s Run History Description, you can view error messages related to data import failures from a data source. Additionally, you can check the status, start time, and end time of the data pipeline execution.

​
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.