T
Thomas Dixon
Guest
Feature Description: The Progress DataDirect for JDBC for Microsoft Dynamics 365 driver supports SQL read-write access for JDBC applications to Microsoft Dynamics 365 applications. To support SQL access to Dynamics 365 apps, the driver creates a relational map of the Dynamics 365 data model and translates SQL statements to Dynamics 365 OData requests. In addition, the driver employs a SQL engine component that provides support to SQL constructs unavailable in Microsoft Dynamics 365. This functionality offers a number of advantages, including support for reporting data and metadata in a form that JDBC applications are ready to use. Minimum Requirements: The driver is compatible with JDBC 2.0, 3.0, 4.0, 4.1, and 4.2. The driver requires a Java Virtual Machine (JVM) that is Java SE 8 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions. Supported Connectivity The driver is supported with the Dynamics 365 Customer Engagement applications: Marketing, Sales, Field Service, Project Service Automation, and Customer Service. Authentication The Dynamics 365 driver supports the following authentication methods: OAuth 2.0 Authentication NTLM (for on-premises Microsoft Dynamics 365 deployments) Connection information required to establish a connection to Microsoft Dynamics 365 using OAuth: ServiceURL TokenURI ClientID ClientSecret RefreshToken You must register an application with the Microsoft identity platform using the Azure Active Directory portal in order to obtain the required connection information. See the Microsoft documentation for specific information on this process: Register an app with the Microsoft identity platform Connection information required to establish a connection to Microsoft Dynamics 365 on-premises deployments using NTLM: ServiceURL Domain Username Password Configuration Manager The driver includes a browser-based tool, Progress DataDirect Dynamics 365 Configuration Manager, that allows you to generate connection URLs, test connections, and execute test queries. To open the Configuration Manager, double-click the driver jar file; or, execute the following command at a command prompt in the directory containing your driver jar file: java -jar dynamics365.jar From the browser window, provide values of the connection properties you want to configure in the corresponding fields. A connection URL will generate in the Connection String field as you provide settings. You can also use the Configuration Manager to obtain access and fresh tokens to populate the connection URL by providing the following information in their respective fields, and clicking the Fetch OAuth Token button: Service URL Authorization URI Token URI Client ID Client Secret Scope Documentation for the various connection properties will be displayed in the right pane of the Configuration Manager when clicking on any property, or its text entry box. Installation Guides: Windows: Progress® DataDirect® Linux: Progress® DataDirect® Installation Notes: The preview installation will expire in 15 days after it is installed. No control numbers are required. For Serial Number you can enter in a numeric value, such as 123. Use Case: JDBC compliant applications needing connectivity to Microsoft Dynamics 365 to perform CRUD operations. BI tools for data analysis. ETL tools performing operations (loading/reading) on data in Microsoft Dynamics 365. Requested Feedback: Are you able to use the driver out of the box? If not, please provide details about the challenges you faced/are facing. What are your primary use cases, and is this driver solving them? Is the driver's performance acceptable for your primary use case? If not, please provide details on your use case, operation being performed, data size, and expectation. Download Information: User's Guide: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=2DLRXU8ITKUTB Windows Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=0WLSWO0VVQSRI All-platforms Installer: https://progress.thruinc.net/Publishing/Link.aspx?LinkID=0W2FK0YMJUDPU
Continue reading...
Continue reading...