メインコンテンツまでスキップ
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday Company

Integration

2019.1 Release Notes for  integration.

Account and Attribute Metadata Loaders

 

Like Other loaders, you map source columns to planning properties. New Account Metadata Loader and Attributes Metadata Loader for creating or updating GL accounts and attributes. 

Metadata Bulk APIs

You can synchronize metadata defined in an external system to Adaptive Insights on a regular, scheduled basis:

  • updateAccounts API: GL accounts only
  • updateAttributes API: Attributes and attribute values

See updateAccounts and updateAttributes .

These single-entity APIs are no longer available with the release of API v20:

  • createDimension
  • updateDimension
  • createDimensionValue
  • updateDimensionValue
  • createLevel
  • updateLevel

For single-entity creation or update in API v20 and beyond, use the metadata bulk APIs of updateDimensions and they will continue to function with previous API versions updateLevels

Functions for Replacing Text 

When you write expressions for custom SQL columns in a data source staging table, you can now use:

  • REPLACE: Replaces all instances of [text_expr_1]in [text_expr_3]with the value [text_expr_2].
  • REGEX_REPLACE:Replaces all instances that match the regular expression [text_expr_1]in [text_expr_3]with [text_expr_2].
  • TO_ACCOUNT_CODE: Removes all spaces and then replaces any non-alphanumeric characters with underscores and truncates values ​​over 2048 characters long.

You can only use these functions in a custom SQL column for a data source staging table.

Support for NetSuite Token-Based Authentication 

In the case of NetSuite 2018.1 release requires two-factor authentication (2FA) for all highly-privileged roles in NetSuite production, sandbox, development, and Release Preview accounts. In the NetSuite 2019.1 release, 2FA becomes mandatory for API and integration access. NetSuite recommends using token-based authentication (TBA) to implement 2FA for API and integration access.

With the Adaptive Insights 2019.1 release, you can upgrade to NetSuite 2018.1 and leverage TBA for data integration between Adaptive Insights and NetSuite. This enhanced security supports these data integration approaches:

  • NetSuite Basic integration
  • NetSuite Enhanced (advanced) integration
  • この記事は役に立ちましたか?