cancel
Showing results for 
Search instead for 
Did you mean: 

Send full extract of table to PI

former_member977381
Discoverer
0 Kudos

Hi Everyone,

     What is the best automated way to send a full extract(roughly 2000 rows) of a table to PI? i am thinking of using workflows in Data Manager, but i am not sure on how to set-up a full extract of a table for this. This has to be done daily.

     All suggestions would be appreciated. Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Richardson,

This can be achieved using a automated port with a map.

You will have to preprare map listing fields to be sent from the table.This can be scheduled daily and records sent can be picked by PI.

Please refer to Syndicator guide for detailed steps.

Thanks,

Ravi

Answers (2)

Answers (2)

former_member977381
Discoverer
0 Kudos

Thank you so much for your answers guys! you have provided so much help!

Former Member
0 Kudos

Hello Richard,

U can schedule this in console on daily basis under admin - > port for automatic daily syndication


Under map properties tab in syndicator for particular map maximum records per file should be zero


If u want to send full extract regularly suppress unchange record in map properties need to be disabled.


Thanks

Keerthi

Former Member
0 Kudos

Hi Richardson,

You can try this by using Ports in console, there is an option of 'Processing interval' make it as daily.

Create a map in syndicator and make suppress unchanged record disabled and also attach that map to your outbound ports.

thanks

Shikhar