var odbc = 0;
 function onRefresh()
 {
	if (!odbc)
	{
 	// Set the connection string
 	var odbc = Engines.ODBC.newDataSource("Provider=sqloledb;
 		Data Source=myServerAddress;Initial Catalog=myDataBase;
		User Id=myUsername;Password=myPassword");

	// Or, in case of Active Directory:
 	// var odbc = Engines.ODBC.newDataSource("Provider=sqloledb;
	//	Data Source=myServerAddress;Initial Catalog=myDataBase;
	//	Integrated Security=SSPI;");

	 }

	// If connection to the database is successful, proceed with the query
 	if (odbc.connect ())
 	{
		// Set up the database object with a query
 		odbc.setQuery("SELECT * FROM Production.Product
				WHERE ProductID < 300");

 		// Or, for a stored procedure:
 		// odbc.setQuery( "EXEC dbo.uspGetEmployeeManagers 6" );

		// Send the query to the database
 		if (odbc.sendQuery ())
 		{
			// If the query is successfully sent, get the response object
			// in XML format
 			var query_resp = odbc.response.xml;

			// Print out the XML data in Debug Window
			trace( query_resp );
 		}
		// If sending of the query to the database fails, output the error
		else {
			traceln( "Could not send the query: " + odbc.getLastError() );
			// Disconnect from the database
			odbc.disconnect ();
		}

		// Disconnect from the database
 		odbc.disconnect ();
 	}
	// If connection to the database fails, 
	// output the error from the ODBC driver in the Debug Window
	else {
		traceln( "Could not connect to database: " + odbc.getLastError() );

		// Disconnect from the database
		odbc.disconnect ();
	}

	// Return the XML data for Klipfolio Dashboard to parse using
	// stylesheet settings
	return Engines.Data.process (query_resp);

 }
 

 <style>
 	z:row::attribute( columnHeaderName ) {
  		...
  		}
 	z:row::attribute( columnHeaderName ) {
  		...
  		}
 	z:row {
  		type: item;
  		definition: all;
  		}
 </style>