Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Murali Kakarla (MuraliK9593)
SMS Management & Technology

SMS Management & Technology
AU
MuraliK9593 Member since 2016 10 posts
SMS Management & Technology
Posted: Jan 9, 2017
Last activity: Jan 9, 2017
Posted: 9 Jan 2017 0:42 EST
Last activity: 9 Jan 2017 18:32 EST
Closed
Solved

Transform data using BIX

Hi,

Is it possible to transform data in BIX ectract rules?

For example, we have FirstName (Alpha) and LastName (Beta) properties in Pega DB. In the BIX extract to a database we want to concatenate values of FirstName and LastName separated by a space and insert value into a column called Full_Name (Alpha Beta) of taget database table.

I have gone thorugh the BIX documention and also help file for BIX extract rule but I did not find any such configurations being available in BIX. My understanding of BIX is that it is juat an "extract and load" tool. It is not "extract, transform and load" tool. Is this correct?

Pega version: 7.2.1

Regards,

Murali

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Data Integration
System Administration

Accepted Solution

Posted: 7 years ago
Posted: 9 Jan 2017 2:15 EST
Sudhish Othoyoth Puthiyapurayil (othos) Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Murali,

As per the below link  BIX is ETL .But BIX does not provide full ETL capabilities, you must use other tools to transform extract table data when migrating it into the required fact and dimension tables.

https://pdn.pega.com/bix-design-models

Regards,

Sudhish OP

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice