Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Connection to Enovia (Matrix Query Language)

My company uses a Product Lifecyle Management software called Enovia.  We want to extract some product design review information to report in Incorta.Does Incorta have the capability to connect to databases that use a Matrix Query Language?3DEXPERIEN...

olekern by Ranger
  • 970 Views
  • 2 replies
  • 0 kudos

Incorta Regex formula

Hi,  I am trying to get regex to work in a materialized view but keep running into "undefined function" errors Is there something wrong with my format? SELECT Name,                  UniversalId,                  Item_Description,                 REG...

Resolved! Why are primary keys important?

We noticed that starting in 2023.7 we are getting error messages in the loader status, if the Enforce Primary Key Constraint option isn't selected with Primary keys setup in the table.  Screenshot below. Someone on our team asked why we even need pri...

JC_Data_Wizard_0-1696883505198.png

Dynamic SQL to union current and future tables

Hello,    I am trying to union 36 tables together. The challenge comes in because there is another table that I need to union each month. So next month ill have 37 tables and the following ill have 38. Is that something we can do within Incorta? Tryi...

TCoomes by Partner
  • 538 Views
  • 1 replies
  • 0 kudos