Frequently Asked Questions about CData MCP Server for Oracle Financials Cloud

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. An MCP Server acts as a bridge, allowing AI models to access and interact with external data sources and tools.

Q: What does CData MCP Server for Oracle Financials Cloud do? A: It allows you to connect to Oracle Financials Cloud data from Claude Desktop through CData JDBC Drivers, enabling natural language querying for live data.

Q: Is this MCP Server read-only? A: Yes, this particular server is read-only. However, free (beta) read/write servers are available at https://www.cdata.com/solutions/mcp.

Q: What is the CData JDBC Driver? A: CData JDBC Driver connects to Oracle Financials Cloud by exposing it as relational SQL models. This allows the MCP server to translate natural language queries into SQL for data retrieval.

Q: Do I need to know SQL to use this? A: No, you don’t need to know SQL. The MCP server translates natural language questions into SQL queries for you.

Q: Where do I download the CData JDBC Driver for Oracle Financials Cloud? A: You can download it from https://www.cdata.com/drivers/oracleerp/download/jdbc.

Q: How do I license the CData JDBC Driver? A: Navigate to the lib folder in the driver installation directory, run java -jar cdata.jdbc.oracleerp.jar --license, and enter your name, email, and license key (or “TRIAL” for a trial license).

Q: What is a .prp file and how do I create it? A: A .prp file contains connection properties for your JDBC connection. It includes information like the server prefix, name, version, driver path, driver class, JDBC URL, and tables to access. Follow the instructions in the Setup Guide to create this file.

Q: How do I configure Claude Desktop to use this MCP Server? A: You need to create or modify the claude_desktop_config.json file to include the MCP server configuration. The Setup Guide provides detailed instructions and examples for both Windows and Linux/Mac.

Q: My CData MCP Server isn’t showing up in Claude Desktop. What do I do? A: Make sure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and then re-open it.

Q: Claude Desktop can’t retrieve data. What could be the problem? A: Double-check your connection configuration. Use the Connection String builder to create the connection string and ensure it’s correctly entered in the .prp file.

Q: Where can I get help if I’m having trouble connecting to Oracle Financials Cloud? A: Contact the CData Support Team at https://www.cdata.com/support/submit.aspx.

Q: Where can I get help with the MCP server or provide feedback? A: Join the CData Community at https://community.cdata.com.

Q: What is UBOS and how does it relate to the CData MCP Server? A: UBOS is a full-stack AI Agent Development Platform that can leverage the data accessed through the CData MCP Server. UBOS allows you to build custom AI Agents that automate tasks, provide insights, and improve decision-making based on your Oracle Financials Cloud data.

Q: Can I use UBOS with other data sources besides Oracle Financials Cloud? A: Yes, UBOS supports integration with various data sources, allowing your AI Agents to access a comprehensive view of your business data.

Q: Where can I learn more about UBOS? A: Visit https://ubos.tech to learn more about the UBOS AI Agent Development Platform.