To use this approach, see ODBC Workday 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: Workday data is copied into a FileMaker Pro database and can be refreshed on demand. The CData JDBC Driver for Workday 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 Workday as a remote MySQL database. We are a hospital, therefore we only qualify for the healthcare/non-profit discount.This article shows how to use the CData JDBC Driver for Workday 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.
This difference is because UC qualifies for the educational discount whereas Children’s Hospital does not. Although Cincinnati Children’s Hospital is affiliated with UC, we are not a degree granting institution. There is a difference in the price of software purchased from Biomedical Informatics at Children’s Hospital versus from the UC Bookstore. Since Children’s Hospital is a separate entity from UC, installing software purchased from UC on CCHMC owned computers is a violation of that license agreement. However, when purchasing from UC, the license agreement states that the software can be installed only on your personally owned or UC-owned computer and not on machines owned by other institutions. Please make sure you read the license agreement carefully before you use UC software.įaculty and students of UC are eligible to purchase software from UC.
In many cases this software is licensed specifically to UC employees only (i.e., people who receive paychecks from UC) or must be run on UC-owned or controlled equipment, making it inaccessible to Cincinnati Children's personnel. UC researchers are served with desktop software by UCIT.
0 kommentar(er)
