This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the DSN, you may also want to set the Max Rows connection property. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.Obtains a new access token when the old one expires.Extracts the access token from the callback URL and authenticates requests.The Driver then completes the OAuth process. Log in and grant permissions to the Driver. When you connect the Driver opens the MS Planner OAuth endpoint in your default browser. This is required to work with an organization not on your default Tenant. Tenant (optional): Set this if you wish to authenticate to a different tenant than your default.You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken. InitiateOAuth: Set this to GETANDREFRESH. Below are the minimum connection properties required to connect. You can connect without setting any connection properties for your user credentials. Modifying iODBC's system-wide settings requires elevated permissions to do so, you can use following to open a text editor from the terminal: You can find the correct odbc.ini in the following paths: System data sources can be accessed by all users. User data sources can only be accessed by the user account whose home folder the odbc.ini is located in. You can define ODBC data sources in sections in the odbc.ini file. To activate a trial license, omit the key input.Ĭd "/Applications/CData ODBC Driver for Microsoft Planner/bin" In a terminal run the following commands to license the driver. This makes the driver easy to use with these tools. The CData ODBC Driver for Microsoft Planner is preconfigured for the iODBC driver manager, as are many other products like Microsoft Excel. Installing the CData ODBC Drivers on Mac OS X This article walks through creating a DSN for Microsoft Planner data in iODBC and accessing Microsoft Planner data in Microsoft Excel, all on a machine running Mac OS X. Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |