ERPNext Connect with MS-Sql Server on Ubuntu 22.04.5 LTS with Window

1. //Create Virtual Environment and Install Dependencies

sudo apt update
sudo apt install python3.10-venv
python3 -m venv venv
source venv/bin/activate

pip install pyodbc requests

2. //Install ODBC Driver for Microsoft SQL Server

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list

sudo apt-get update

sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17 unixodbc-dev
odbcinst -q -d -n "ODBC Driver 17 for SQL Server"

3. //Configure SQL Server
Ensure that your SQL Server allows remote connections and you can access it from your Ubuntu environment.

4. //Generate API Key and API Secret for ERPNext
	1-Log in to ERPNext as an Administrator.
	2-Generate an API Key and Secret by going to User Settings and creating an API key.
	3-Save these credentials securely, as you will use them to authenticate the API requests in the script.


5. //Create and Write the Python Script
Create a Python file called erpnext_sql.py in your desired directory.
You can download or copy the provided code from the Bellow link.
https://www.thiscodeworks.com/embed/66f3fc60f4dcb900149d8681
5.1. //Using nano to Create and Edit the File:
nano erpnext_sql.py
//Copy data from the above link and Configure your API, SQL Setting, and Save it
To save and exit:
    Press CTRL + O to save the file.
    Press Enter to confirm the filename.
    Press CTRL + X to exit nano.

    Customize the Python script as necessary to suit your SQL Server data import logic and ERPNext API interactions.


6. Create a file "last_imported_timestamp.txt"
	# Define path to the timestamp file
timestamp_file_path = '/home/erpnext/last_imported_timestamp.txt'
	# Default timestamp value
default_timestamp = '2000-01-01 00:00:00'


7. Run the Python Script Manually
//"python3 file_name"
python3 erpnext_sql.py
-----------------------------

source venv/bin/activate
python3 erpnext_sql.py