What you can do with Oracle Database in Sylus
Sylus gives enterprise teams an AI data analyst on top of Oracle Database. Ask "What were monthly shipments by warehouse this year?" or "Which accounts have the highest outstanding balance?" and get answers, charts, and dashboards, with the SQL shown for review.
How the Oracle Database integration works
Sylus connects with an Oracle connection string and a user that only has SELECT privileges. It reads your schemas, tables, and views, then queries the objects you select. It works with on-premises Oracle Database and Oracle Cloud, including Autonomous Database.
Questions you can ask about your Oracle Database data
Finance
What is revenue by month from our billing data?
Which customers have the highest outstanding balances?
Which invoices are more than 60 days past due?
How do this quarter’s costs compare to last quarter by department?
Sales
Who are our top 20 customers by order value this year?
Which products have the fastest growth in orders this quarter?
How many new customers did we add each month this year?
What is our average order value by region?
Operations
Which items are running low across our warehouses?
What is the average time from order to shipment this month?
Which suppliers have the most delayed deliveries?
How many orders are in each processing status today?
Leadership
How are revenue and order volume trending against last year?
Which regions grew fastest this quarter?
What changed most in our key metrics this month?
Give me a weekly summary of orders, revenue and receivables.
How to connect Oracle Database to Sylus
You need a DBA who can create a read-only user.
Create a database user for Sylus and grant it CREATE SESSION plus SELECT on the tables and views you want to analyze.
In Sylus, add Oracle Database as a data source, enter the connection details, and test the connection.
Select the schemas, tables, and views to include.
Connection string format: oracle://user:password@host:1521/service_name
