Data & Schema Discussions

Resolved! Calculations in Schema

Two questions - 1. Round - according to documentation and per our testing round only works to the nearest whole integer. Anyone find a way to round to two decimals (like you can in Oracle SQL developer or excel?)Ex. 2.5621 in incorta will round to 3 ...

Formula column expression editor - what determines whether a table shows up?

I'm trying to build a formula column. Using the lookup() function, but I don't suspect that's meaningful to this question. - The schema has 45 tables in it. Only 9 of them show up in the expression editor's dialog box ( left side ) - Of the 45 ...

Unable to load SharePoint Online List data

I have setup OAuth connection with SharePoint Online and configured Datasource using it. While testing connection it shows Successful.But when I try to load data in Schema table, it only fetching metadata/columns but not the records.In Load status, N...

Incremental Loading - how do you use it after 5.1?

Hello - we are in the process of upgrading from 5.0 to 5.2 and have noticed a new requirement in 5.1. Changing a 'Key' column in a physical table now requires a full load of that table. We use incremental loads to load daily snapshots from source s...

Incorta against No SQL database

Hi - Has anyone tried Incorta schemas on NO SQL database like Mongo DB? can we use Incorta to pull JSON format data ?