Question 1

Does TextQL work with Oracle EBS and other Oracle Applications?

Accepted Answer

Yes. TextQL can connect to the underlying Oracle database that powers Oracle E-Business Suite, PeopleSoft, JD Edwards, and other Oracle Applications. Ana discovers the application tables and can query them directly. For best results, connect with a read-only user that has access to the relevant application schemas.

Question 2

Can TextQL handle Oracle's synonym and schema structure?

Accepted Answer

Yes. TextQL resolves public and private synonyms during schema discovery, so Ana knows the actual table locations regardless of how your Oracle database uses synonyms. It also navigates multi-schema architectures common in enterprise Oracle deployments, joining across schemas as needed.

Question 3

Does TextQL support Oracle Autonomous Database?

Accepted Answer

Yes. TextQL connects to Oracle Autonomous Database (both Transaction Processing and Data Warehouse workloads) using the same connection method as any Oracle database. Provide your wallet or mTLS credentials during setup. All features work identically on Autonomous and traditional Oracle deployments.

Question 4

How does TextQL handle Oracle partitioned tables?

Accepted Answer

TextQL discovers partition schemes during schema introspection. Ana generates queries that include partition pruning predicates when applicable — for example, adding date range filters that align with your range-partitioned tables. This ensures queries scan only relevant partitions for better performance.

Question 5

Can I query Oracle data alongside modern cloud warehouses?

Accepted Answer

Yes. TextQL's multi-source capability lets you join Oracle data with Snowflake, BigQuery, Databricks, or any other connected source in a single question. This is especially powerful for organizations migrating from Oracle — you can correlate legacy and modern data without complex ETL pipelines.