Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Can Alteryx connect to a PeopleSoft Query?

mschembr
5 - Atom

Hi,

My leader is asking me to try to automate a use case that begins with a PeopleSoft query.  Can someone at a high level answer if this is possible to do?

 

1) Do I need to have a database account to do this or am I able to connect to with just query access?

2) I assume I need to format the query in a different way than standard PeS Query logic, correct?

 

Thanks in advance!

2 REPLIES 2
tonypreece
10 - Fireball

1. You can connect to the underlying Oracle database using either an Oracle or ODBC connection within the Input Data tool. You'll need the database location and access permissions.

2. Once connected you should be able to build a query on the database rather than using the PeopleSoft query.

 

https://help.alteryx.com/2018.2/OracleConnections.htm

mschembr
5 - Atom

HI Tony,

Thanks for the reply!  I thought database permissions might be required for this.  Appreciate you confirming!

 

Mark S.

Labels