SQL Queries for SQL Server Datasource
We are planning to migrate from Cognos to Domo.
1. Issue is we have prebuilt Custom SQL queries with Joins/Unions/logics etc,Views which should be as it is used in Domo.
I know using Domo workbench we can create a connection to Onpermisses database but will it allow complex SQL queries which will be of 2-3 pages length to be integrated in DOMO.
2. Currently few excel reports we have to rebuild in Domo. I know domo has excel connector but is it possible to join 3-5 different sheets in single dataset. I mean do we have some data modeling abilities in excel connector ?
What i know is create 3-5 individual datasets and then combine them using Magic ETL/Fusion. But i just want one single dataset in which i can create all instead of depending on multiple objects/steps.