Can Alteryx connect to a PeopleSoft Query?

Question

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!

tonypreece · Accepted Answer

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