Data & Schema Discussions

SQL server connector

Hi,I'm unable to connect to SQL Server.I am trying to connect to Sql server Jtdc and selected windows auth ,passed all the connection details, getting sql authentication failed error.

CDATA Configure schema tables are taking longer to load

Hi,I have data source as CDATA(most of the data is from API), when performing schema load its taking longer compared to RDBMS.is there any way to increase the performance ?

Pivot Raw Data

Hello,Is there any way to Pivot some of the raw data columns (not in PySpark) prior to using the data for analytics?Also, Is there any way to use Python instead of PySpark in the MV creation?

connect to outlook data in incorta

Hi Community,I'm looking to connect to outlook email data for some analysis.Is there a custom connector in incorta to do so ? Or is it possible to connect to a power apps (dataverse table) ?Thanks in advance!

Resolved! Formula to convert Long datatype field to DateTime format without materialized views

Hello !I have a few database tables that store a datetime value as a Long/Big Int Value. I was windering if there is a formula in incorta that i can use to retreive these values in the original datetime format.Kindly find an example below:Stored Valu...