MS SQL Server Table

Parameter
Value
connectionString
the encrypted connection string. See https://www.connectionstrings.com/sqlconnection/ for a sample.        
object
the name of the object without the schema, e.g.employees
Before 4.0
connectionString: the encrypted connection string. See https://www.connectionstrings.com/sqlconnection/ for a sample.
schema: sql schema, if any. e.g. dbo
table: the name of the table without the schema, e.g.employees 
<SqlServerDataSource
	schema="dbo" 
	table="employees" 
	connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU=">
	<Schema>
		<Column name="employee_id" ordinal="1" dataType="Number" />
		<Column name="name" ordinal="2"  dataType="Text" />
	</Schema>
	<Filter/>
</SqlServerDataSource>
CLI 4.0+
connectionString: the encrypted connection string. See https://www.connectionstrings.com/sqlconnection/ for a sample.
table: the name of the table including the schema, e.g. dbo.employees 
<SqlServerDataSource 
	table="dbo.employees" 
	connectionString="DDE1MhWuA0xYbwFvSnu1fEZ2uD2GpsMRdw9DMV/kmMAfLUdkhkdzrD0Ikk/9dd114wRu9VKrVPSztrcIcSyz2UEFRRANfocc8KJEQXfKDuU=">
	<Schema>
		<Column name="employee_id" ordinal="1" dataType="Number" />
		<Column name="name" ordinal="2"  dataType="Text" />
	</Schema>
	<Filter/>
</SqlServerDataSource>

MS SQL Server Query

ODBC Table

Last modified 1yr ago

Parameter	Value
connectionString	the encrypted connection string. See https://www.connectionstrings.com/sqlconnection/ for a sample.
object	the name of the object without the schema, e.g.employees