This will limit the number of rows returned, which is especially helpful for improving performance when designing workflows. When you configure the DSN, you may also want to set the Max Rows connection property. Additionally, to use internal authentication set the User and Password connection properties. Set the Server, Port, and Database connection properties to connect to Cassandra. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). SQL functions and JOIN operations).Ĭonnect to Cassandra as an ODBC Data Source When you issue complex SQL queries from Power Automate to Cassandra, the driver pushes supported SQL operations, like filters and aggregations, directly to Cassandra and utilizes the embedded SQL engine to process unsupported operations client-side (e.g.
#Microsoft dynamics pos odbc connection drivers#
Through optimized data processing, CData ODBC Drivers offer unmatched performance for interacting with live Cassandra data in Microsoft Power Automate.
#Microsoft dynamics pos odbc connection how to#
This article shows how to integrate Cassandra data into a simple workflow, moving Cassandra data into a CSV file. The CData ODBC Driver for Cassandra enables you to access live Cassandra data in workflow automation tools like Power Automate.
0 kommentar(er)
