How Can I Configure CloudSuite Field Service to DataLake and then connect to Power BI?

unknown

I'm ultimately trying to create a live connection to the Cloudsuite Field Service cloud edition from Power BI.

CloudSuite Field Service ERP has a configuration guide that explains how to connect it to the DataLake. In one of the steps it says to create a Replication Rule and set the Source Site to DataLake AND the Target Site to DataLake. When I do this and Generate the Schema, it doesn't do anything. However, if I make the Source Site to be the Default site and the Target Site to be DataLake it does send the schema to the Data Catalog. HOWEVER, when I try to query any of the tables, there's no data. There must be a step I'm missing?

Also, once I've done this, how can I then connect Power BI to the DataLake? If I can't connect Power BI directly to the Data Lake, I have installed the JDBC Compass driver and have it connected to DBeaver. Is it possible to connect Power BI through DBeaver? If so, anyone know what driver or connection source do I use?

unknown

Hey Terrence,

Have you managed to make any headway here?

It sounds like when you were configuring your replication in Field Service, it registered the metadata in Data Catalog but you likely needed to make sure your Data Flows in ION Desk were updated so that the connection point is publishing this data and other applications are subscribed to receive it - specifically, Data Lake. That's perhaps one reason why you may not see the data in Data Lake until that point.

Most Power BI or 3rd party analytics users tend to ETL data from the Data Lake to a data warehouse where the data can be managed within the analytics lifecycle. Power BI in particular doesn't support JDBC but in general, the industry best practice would be to pull copies of data from Data Lake and store that in an EDW that Power BI can read from.