Compared to a native ODBC integration, FileMaker Pro integrations that use MySQL remoting have several additional components. The JDBC driver is part of a data access chain. The remote data can be modified in FileMaker Pro and tables can be used in the relationships graph like standard FileMaker Pro tables. To use this approach, see ODBC Jira Service Desk Integration in FileMaker Pro.ĮSS: Instead of working with a local copy of the data, you can use the JDBC driver to create an external SQL source.
To streamline this solution, use the CData ODBC driver, as FileMaker Pro supports ODBC natively, but it does not support JDBC. There are two data access modes in FileMaker Pro:ĭata Import: Jira Service Desk data is copied into a FileMaker Pro database and can be refreshed on demand. The CData JDBC Driver for Jira Service Desk implements both the JDBC and MySQL standards to integrate with applications like FileMaker Pro that support connections to traditional databases like MySQL but not generic JDBC connections. You will use the MySQL Remoting feature to access Jira Service Desk as a remote MySQL database. If you invest some time into formatting and scripting the database, there is a high ease of use for users without knowledge of any programming or FileMaker itself.This article shows how to use the CData JDBC Driver for Jira Service Desk to integrate with the External SQL Sources (ESS) feature in FileMaker Pro, which allows you to link records in FileMaker Pro with related records in your other operational data stores.We have users with Macs, PCs, iPhones and handheld tablets linked to our FileMaker database and they are updating the information constantly throughout the day. The server license allows many users to update the database in real time, which is handy if your inventory is constantly changing.Almost all of our internal data is linked to the FileMaker database This allows for greater UI, especially with active users who are not familiar with writing code. The scripting language allows FileMaker to automatically calculate complex algorithms automatically or generate report outs with the click of a button.It has the capability to incorporate barcoding, which can manage your available inventory with ease. You can add a ton of information to each record and update your inventory on a regular basis with an Excel import or manually inside of the record. The relational database management system makes the program highly customizable to fit the needs of any product.
0 kommentar(er)
