![]() 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). And with PolyBase, you can also join SQL Server data with Sage 300 data, using a single query to pull data from distributed sources. ![]() When you issue complex SQL queries from SQL Server to Sage 300, the driver pushes down supported SQL operations, like filters and aggregations, directly to Sage 300 and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. The CData ODBC drivers offer unmatched performance for interacting with live Sage 300 data using PolyBase due to optimized data processing built into the driver. This article walks through creating an external data source and external tables to grant access to live Sage 300 data using T-SQL queries. When paired with the CData ODBC Driver for Sage 300, you get access to your Sage 300 data directly alongside your SQL Server data. PolyBase for SQL Server allows you to query external data by using the same Transact-SQL syntax used to query a database table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |