Developer Programs
Vendor Integration Program (VIP)
Direct access to Jack Henry's technical integration resources.
Technical Account Manager (TAM)
Get technical integration help from a single point of contact.
Developer Account
Create a developer acccount to access resources that help you integrate with Jack Henry.
Learn
Shared Responsibility
Learn about shared roles and responsibilities of customers and Jack Henry in open banking.
Developer Use Cases
Find a use case that fits your development needs.
Developer Video Gallery
Watch the latest demos, webinars, and more.
Developer Conference
Connect with industry leaders, gain insights from expert speakers, and explore our latest innovations.
Docs
Admin API
Create solutions for an institution's back office support tools.
Authentication Framework
Map customer identities to your existing system IDs.
Consumer API
Access financial data for user accounts, transactions, and more.
Data Hub
Get deeper access to financial institution data.
Enterprise Event System
Respond to events in real-time using this powerful pub/sub-based solution.
jXchange - REST API
Translate business information between Jack Henry and 3rd-party apps using a REST-based API.
jXchange - SOAP API
Translate business information between Jack Henry and 3rd-party apps using a SOAP-based API.
Operational Data Integration (ODI)
Get customized queries for bulk data needs.
Payments
Embed check deposits, ACH, bill pay, cards, and real-time payments.
Plugin Framework
Embed the best of the fintech world directly into your user's dashboard.
SymXchange
Query Symitar core member accounts, post transactions, run PowerOn scripts, and more.
Xperience
Modern UI that provides consistent visual integration across Jack Henry products.
Full List of APIs
Begin working with Jack Henry's public APIs to build financial applications today.

Entity Services

Pipelined Data Sets > Entity Services

Introduction

The goal of this pipeline is to make the Entity Services datasets available in Google Big Query where it can be queried using the SQL interface for business purposes and to drive downstream business processes.

Scenarios

Customers can obtain comprehensive details about any legal identity, whether individual or commercial, and their relationship activities with financial institutions. It consolidates customer and demographic information, providing a snapshot of entity relationships at any given time, making it a crucial tool for understanding and managing these connections.

Pipelines

The Entity Services pipeline utilizes BigQuery External Connections in the Data Hub project, to the Publisher Spanner database in their project. Federated Queries are used with External Connections to the Spanner databases from BiqQuery. The Federated Queries are used to pull data from the Spanner Database into the BigQuery datasets / tables.

Entity Services Datasets

Currently Entity Services utilizes two datasets in Data Hub.

  • entity_svcs_entity_us
    • Table Name
      • address_change_fct_cdd
      • address_fct_cdd
      • address_label_fct_cdd
      • affiliate_opt_out_fct_cdd
      • affiliate_opt_out_type_fct_cdd
      • chapter_exemption_fct_cdd
      • chapter_status_fct_cdd
      • contact_change_fct_cdd
      • country_code_fct_cdd
      • digital_contact_point_fct_cdd
      • digital_contact_point_label_fct_cdd
      • digital_contact_point_type_fct_cdd
      • disability_fct_cdd
      • employment_fct_cdd
      • entity_fct_cdd
      • entity_settings_fct_cdd
      • entity_subtype_fct_cdd
      • ethnicity_fct_cdd
      • gender_fct_cdd
      • identification_fct_cdd
      • identification_type_fct_cdd
      • income_level_fct_cdd
      • insider_role_fct_cdd
      • legal_entity_exclusion_reason_fct_cdd
      • phone_change_fct_cdd
      • phone_label_fct_cdd
      • phone_number_fct_cdd
      • phone_settings_fct_cdd
      • privacy_opt_out_fct_cdd
      • privacy_opt_out_type_fct_cdd
      • pronoun_fct_cdd
      • race_fct_cdd
      • state_code_fct_cdd
      • tax_id_type_fct_cdd
      • w8_type_fct_cdd
      • withholding_type_fct_cdd
  • entity_svcs_relationship_us
    • Table Name
      • relationship_fct_cdd
      • relationship_type_fct_cdd

Schedule

The Federated Queries are scheduled to run hourly.

Topics in this section

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Mon Feb 24 2025