FAQ

Quick Q&A on BI Connector!

Is BI Connector secure?

Yes. BI Connector respects Oracle Fusion’s native Role-Based Access Control (RBAC). Users can only query data they are authorized to see in Fusion, maintaining strict security governance.

Can I export data from BI Connector?

Yes. BI Connector provides one-click export to CSV and Excel formats directly from the results page – no additional navigation required.

Does BI Connector track query history?

Yes. BI Connector automatically records detailed execution history including:
• Connection used (DEV/TEST/PROD)
• Query name and SQL preview
• Rows returned and timestamp
• Execution count
This provides a complete audit trail and allows you to re-run previous queries instantly.

How many SQL tabs can I open simultaneously?

BI Connector supports 10+ simultaneous SQL tabs, allowing you to work on multiple reports, compare queries, and test variations without losing context.

Can I format my SQL automatically?

Yes. BI Connector includes a one-click SQL auto-formatter that restructures and beautifies code instantly – aligning keywords, indentation, and nested conditions for professional, readable SQL.

Does BI Connector work with all Oracle Fusion modules?

Yes. BI Connector works with all Oracle Fusion modules including Finance (GL, AP, AR), Projects, Supply Chain (SCM), Human Capital Management (HCM), and others.

What are these prebuilt queries shown on the site?

They are commonly used SQL examples for Oracle Fusion modules — like Payables, Receivables, and Projects. These give you an idea of what kind of reporting or data extraction is possible.

Are the queries on the page available for direct purchase?

No. These queries are not sold individually. They are sample references. We offer custom query development as a service — you tell us your reporting need, and we build the query for you.

How do I request a custom SQL query?

Just click on the “Create a Custom Query” button and submit your requirement (module, fields, filters, business logic). Our team will review and share an estimate.

What’s the turnaround time for custom queries?

It depends on complexity. Simple queries may take 1–2 days, while complex, multi-source queries may take up to a week.

Are you ready to unlock the
full potential of your Oracle data?

Got questions?

Talk to our Power BI and Tableau-Oracle integration experts!