Get columns from data source

Sgorham

• December 13, 2024 15:09

Currently we are using SQL server as our datasource for multiple sites. Each night, we want to update the schema in LOGI to match whatever is present in the database at that time.  We currently have a program that will login to each site, and click the "Get Tables and Joins from Data Source".  This is working great, however if there is a new table, it is loaded into the schema without any of the columns.  Is there a way to update/refresh the entire metadata?  The only solution right now is to go into each table and hit the "Get Data columns from data source" button.  Does anyone know how we can do this on an automated basis? Thanks! 

0

• 

  VISUI

  • Logi Info Ninja
  • December 13, 2024 23:23

  The metadata file is an XML document. You can programmatically create the document dynamically from your database server instead of relying on Logi’s metadata builder to be run nightly.

  0

Please sign in to leave a comment.