community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to perform Scheduling from Oracle database using Alteryx Designer?

Highlighted
Meteoroid

Hey everyone! 

 

I have a query regarding the scheduling process in Alteryx (admin version). I want to schedule the extraction of tables from the Oracle database. For this, I'm using Alteryx Designer with Scheduler. 

 

I've tried scheduling using the input tool. The error message popped up in the scheduler window: 

"Unable to translate Alias"

 

Any suggestions? TIA!

 

Alteryx Certified Partner
Alteryx Certified Partner

@NancySidhu,

 

On your desktop you have created an OCI string that isn't define on your server.  The Oracle connection needs to exist on both environments.  Either you need to define the connection string on the server or use something like the following:

 

oci:<user id>/<password>@<Host Name>:<port>/<Database>

oci:marqueecrew/mEYEpa$$w0rd@prod.marqueecrew.com:1725/PRDDATA

 

That might solve your need.  I like https://www.connectionstrings.com for help.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels