How to Access SQL Server in ION Scripting using python?

Legacy Contributor

Hi All,

I have tried to connect SQL server in ion scripting using pyhton.

pymssql is used as linux version of pyodbc module is not available in https://pypi.org/

I am unable to connect to sql server using pymssql ,PFB for the issue.

Could you please let me know how to connect MS SQL Server in ION Scripting.

Thanks,

Anish k.

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

All comments

Legacy Contributor

Hey Anish,

You cannot call outside services, APIs, or systems from within a script today. Rather, scripts can only be run as either part of a process flow (Data Flows, shortly Workflows) or via an API in the API Gateway. Typically, the script is a self-contained package including your Python code, any libraries you've included, and the payload(s) used for processing.

I'd be interested in hearing more about the use case that you have in mind and what you're trying to accomplish. Is it simply an enrichment scenario?

Legacy Contributor

Hi Mike ,

We are trying to create a sequenceID for each record in payload using SQL server table.

sequenceID is used as variation ID for that payload.

Thanks,

Anish Kulkarni.

Legacy Contributor

Hey Anish,

Are you using the ION Database Connector to grab data and publish it into a BOD format? Or are you doing something else entirely?

You should be able to calculate a sequenceID in the local SP or perhaps use the ION Mapper, depending on the scenario and data available.

Legacy Contributor

Hi Mike,

We are using python script to convert system link response(XML) to JSON and publish it to datalake using file connection.

we want to use sql table to capture a ID for each object(xml) and refer it in python script.

Thanks,

Anish Kulkarni.

Legacy Contributor

We build a lib to do this - check

PyPi

https://pypi.org/project/inforion/

Docker:

https://data-management-via-infor-ion.readthedocs.io/en/latest/

https://hub.docker.com/r/fellowconsulting/inforion

Legacy Contributor

Hi Thomas,

we are not using directly sql data to load into datalake. We are converting xml to json ,to assign sequence id to json we are using sql table .

Can we use this module in ion scripting?

Could you share example of how to use this module in ion scripting.

Thanks,

Anish k.

Copyright © 2025 Infor. All rights reserved.