Question
Express Scripts.com
US
Last activity: 10 Jan 2018 15:45 EST
BIX Extract data to Teradata
Has anyone tried BIX extract data to Tera data. How can we automate to expose data and load into Teradata for reporting?
Pegasystems Inc.
IN
Express Scripts.com
US
Thank You. I assume you are referring to use the extract rule destination as database. How can I automate this extract rule to perform the extract to my destination Teradata database to sync the data live or atleast once in a hour?
Pegasystems Inc.
IN
In order to extract the data to Teradata, you have to create a Rule-Admin-Database record and gave the teradata jdbc url.
Express Scripts.com
US
Ok Thank You. Instead of one time extract, can we make it sync up live from my Pega(oracle DB) to Teradata using BIX extract options if any exists? Or do I need to write activities to do so to execute extract rule at multiple time intervals?
JPMorgan Chase & Company
US
Yes you can run from the activities or from command line by scheduling cron job.
Express Scripts.com
US
I have created Bix extract and able to load data into teradata destination DB successfully. To automate, please share if you can step by step guide for command line or scheduling it thru activity?? Appreciate your help
Pegasystems Inc.
IN
I have never tried this, but, I believe if we can connect to Teradata from Pega through jdbc (through database rule), we can do a database extraction from Bix.
Please add to this if anyone has already tried this
Hi,
please add the Teradata jdbc jar file in the lib directory, add Teradata driver name in <env name="database/drivers" value= > tag of prconfig file and restart the server.
Hi,
please add the Teradata jdbc jar file in the lib directory, add Teradata driver name in <env name="database/drivers" value= > tag of prconfig file and restart the server.
Once this is done do Test Connection on Rule-Admin-Database record. If test connection is successful you may start using BIX to extract data.
Regards,
Narasimha