0
Can I run python script in Alteryx that uses pandas and connects to MS SQL server using pyodbc

I'm a trainee at an organization that uses Microsoft Excel SQL server as database environment and alteryx as application to extract, transform and load (ETL) data. At my university we use MySQL Workbench as database environment and Pentaho Data Integration as application for ETL.

I have a python script that I run in Spyder and it uses the libraries mysql.connector and pandas. Today I came to the conclusion that the organization will not be able to use any of the software I use for school (MySQL workbench, spyder and Pentaho data integration). So I want to transfer and transform my project to the software that the organization IS able to use.

I'm not familiar with Alteryx and haven't used it yet. I found out that alteryx is able to run a python script but for me it's unclear if it has restriction. So my question is: Does anybody know if alteryx can execute a Python script that uses/does the following things?:

  1. import pyodbc, to connect with the SQL server database
  2. import pandas to be able to execute the rest of the script and write a dataframe to Excel

Any answers are welcome and i'll be thankful


Python 25-01-21, 7:06 p.m. soumyarani

Log-in to answer to this question.