Forum Discussion

sanam's avatar
sanam
New Contributor
6 years ago

How to call python script in SnapLogic

Hi Team, I need to call below sample python script from snaplogic. or is there a way to call .py file in snaplogic import pandas as pd ################Can be snap logic pipeline##############...
RogerSramkoski's avatar
RogerSramkoski
Employee
5 years ago

@sanam Hello again! I replied on your separate thread about the RPE hostname (Remote Python Snap Account). What I want to add to this thread is that if you need a third-party Python library the Remote Python Script snap is the way to go and the RPE images we maintain already have Pandas.

From a design perspective, is there a reason your thinking about making the SQL connection in Python rather than using the SQL Server snap pack for the read, then passing the data into the RPE snap for processing with Pandas?

  • RogerSramkoski's avatar
    RogerSramkoski
    Employee
    5 years ago

    @igormicev We do not restrict which third-party Python libraries work in the RPE snap. Custom scripts like this though would be outside the scope of our Support team, meaning they need to be supported by the team that develops them. What is the driving factor to use pyodbc or another Python library to connect to SQL Server instead of the SQL Server snap pack or JDBC snap pack?

    • sanam's avatar
      sanam
      New Contributor
      5 years ago

      Hi,

      Thanks for the reply I have got RPS installed but I am not able to use external lib

      import pyodbc
      from pylab import title, figure, xlabel, ylabel, xticks, bar, legend, axis, savefig
      from IPython.display import Math

      Python script error: ModuleNotFoundError(“No module named ‘pylab’”,)
      I need to conncet to SQL and read the data for further processing
      what is required to use them in the remote python script?