An Igor Pro® plug-in called "SQL XOP" provides access to relational databases from Igor procedures. SQL XOP uses SQL (Standard Query Language).

Database connectivity is provided by ODBC (Open Database Connectivity) drivers on Mac OS X and Windows. MySQL, Microsoft SQL Server, Oracle, Microsoft Access and most other database management systems support ODBC.

Using SQL XOP you can:

  • Connect to an SQL server
  • Execute a query on a database and transfer the result set to Igor waves, variables or strings
  • Add, drop or alter tables
  • Insert rows into tables
  • Update rows in tables

Here is an example of an Igor function that executes a query, transfers the result set to Igor waves, and displays the result set in an Igor table:

#include &ltSQLUtils&gt
Function SQLHighLevelFetchTest1()
	// This connection string references the previously-created data source name IgorDemo1.
	String connectionStr = "DSN=IgorDemo1;UID=DemoUser;PWD=Demo"

	String statement = "Select * from SampleTable"
	SQLHighLevelOp /CSTR={connectionStr,SQL_DRIVER_COMPLETE} /O /E=1 statement
End

Forum

Support

Gallery

Igor Pro 9

Learn More

Igor XOP Toolkit

Learn More

Igor NIDAQ Tools MX

Learn More