MS SQL Server Query

connectionString: the encrypted connection string query
query: the select statement
<SqlServerDataSource 
	query="Select * from 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>

MongoDB Collection (Cinchy Event Triggered)

MS SQL Server Table

Last modified 2yr ago