Using .net System.Data.SqlClient module for database writeback in Spotfire® using IronPython

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

import clr, datetime
clr.AddReference('System.Data')
from System.Data import SqlClient
from System import Threading, DateTime

sql = "INSERT INTO Companies values (123,'Tibco','US')"

conn = SqlClient.SqlConnection("Server=mssqldatabase;Database=mydatabase;UID=spotfire;PWD=spotfire")
conn.Open()

cmd = SqlClient.SqlCommand(sql, conn)
exe = cmd.ExecuteReader()

exe.Close()
conn.Close()

See also

• Writing to files and databases from Spotfire

References

• System.Data.SqlClient

License:  TIBCO BSD-Style License