[teiid-issues] [JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target

[Ramesh Reddy (Jira)]

    [ https://issues.jboss.org/browse/TEIID-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13648767#comment-13648767 ] 

Ramesh Reddy commented on TEIID-4251:
-------------------------------------

IMO, using the "allow-materialization-management" is the simplest way to control it and it will be consistent when we also support Infinispan. We can't be providing two different solutions.  Going with cron jobs,  we would need to devise ways to create these and inject during the pod creations.  "Status" table would give us the ability to create dashboards in UI and ability to ad-hoc management.  If we want we can think about creating "Status" table on disk for OOB scenarios and use PG for the Syndesis like scenarios where we can automate the creation of the tables.

> Built in support for Postgres DB as materialization target
> ----------------------------------------------------------
>
>                 Key: TEIID-4251
>                 URL: https://issues.jboss.org/browse/TEIID-4251
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Server
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 11.2
>
>
> If Postgres database is available along with install or assumed that it is available, then some of the materialization task can be automated, like
> - Creation of a common STATUS table
> - Creation of the materilization targets (create views on dbms)
> - On load, on undeploy and load scripts for all the materialization views
> We need to device a way this to be pluggable, such that based on success of this, we can provide additional support for other sources. 



--
This message was sent by Atlassian Jira
(v7.12.1#712002)