How to custom table/ Columns with EmbeddedServer

jchidiac Nov 24, 2014 4:57 AM

Hi,

Im using EmbeddedServer

and i want to exclude tables on the deploying level

and i want to add/ remove columns for certain tables

and change column dataType

it's possible with EmbeddedServer ?

if yes, can someone give me an example ?

Thx.

1. Re: How to custom table/ Columns with EmbeddedServer

shawkins Nov 24, 2014 8:12 AM (in response to jchidiac)

> and i want to exclude tables on the deploying level

If it's a JDBC translator, it supports several import properties to control what is imported: JDBC Translator - Teiid 8.10 (draft) - Project Documentation Editor see schemaPattern, tableNamePattern, and excludeTables

> and i want to add/ remove columns for certain tables

What's the usecase for adding out of curiosity? Is that something the importer is missing?

As for removing there isn't a direct option for that. Workarounds include: introducing views that omit columns, using data roles to prevent unintended access, or using a custom translator to override the import logic.

> if yes, can someone give me an example ?

The other general option is just to specify all of the metadata via DDL rather than going through an import. See DDL Metadata - Teiid 8.10 (draft) - Project Documentation Editor and Metadata Repositories - Teiid 8.10 (draft) - Project Documentation Editor for using DDL inline in the vdb.xml or using a separate DDL file in a zip deployment.
Actions