Connect Alteryx to CSI SyteLine

Question

My company uses CSI SyteLine(ERP System) earlier we were using Salesforce. I am finding ways to connect Alteryx to Syteline to fetch the data and create the workflows, it is like a database where the set of data is present in a tabular format. Any idea if that is possible? If yes, how to do that.

NicholasBailey · Answer

Hy there i can see your post and i must say

* Data Source Configuration:

* Open Alteryx Designer and start a new workflow. ADP Workforce Now
* Drag and drop the appropriate Input tool (like "Input Data" or "Input Database") onto the canvas.

* Database Connection:

* Configure the Input tool to connect to your SyteLine database. You will need to provide connection details such as the server name, credentials, and database name.

* Query Data:

* Use the Input tool's interface to write SQL queries or select tables from your SyteLine database. This will allow you to fetch the required data into your Alteryx workflow.

Thanks and regards

PhyllisSanchez

Bluebird_Tim · Answer

Hi @NanditaPatil ! I did a quick google search and there seems to an API which would be the best way to access the data.

You would use the download tool to make the api call to the rest API with the credentials & info you need to extract said data.

With a quick google search you can find some examples of people using the download tool to query APIs.