You can translate the question and the replies:

auto create base_view , auto union them

As I'm french speaking with I bad english, I write in french and include an english translation (by GGTranslate). Voici le scénario que je voudrais mettre en oeuvre. # Partie 1 Je veux réaliser une union view qui reprend ce qui se trouve dans des bases view (ca semble simple jusque là) mais je voudrais que l'union soit défini avant la création des bases view. Et avoir l'équivalent d'un wildcard dans le nommage de la base_view En gros que toutes les BV qui on le nom bv_data_xxxx se retrouvent dans uv_data #Partie 2 Dans un principe similaire je automatiser la création d'une bv dès qu'une source de donnée qui apparait dans un sharepoint List ou fichier excel sur un espace accessible et surveillé par denodo ---- Here is the scenario I would like to implement. # Part 1 I want to create a union view which includes what is found in the view bases (it seems simple so far) but I would like the union to be defined before creating the view bases. And have the equivalent of a wildcard in the naming of the base_view Basically all the BVs with the name bv_data_xxxx are found in uv_data #Part 2 In a similar principle I automate the creation of a bv as soon as a data source which appears in a List sharepoint or excel file on a space accessible and monitored by denodo Thank you

1 Answer

Hi, I would make use of the predefined stored procedure, **[GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/generate_vql_to_create_jdbc_base_view)**, which helps in creating wrapper and VQL statements for a given table of the underlying database of a JDBC data source. The values passed to the procedure can be parameterized based on the requirement (i.e schema_name, database_name, table_name etc). In combination with the procedure [GET_JDBC_DATASOURCE_TABLES](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_jdbc_datasource_tables#get-jdbc-datasource-tables ), you can automate the process of having a base view for all the tables/views of a source database. Furthermore, you could make use of the scheduler in order to execute the parameterized query in the VDP with scheduled triggers to help automate the process. You could refer to [Creating Scheduler Jobs](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/creating_and_scheduling_jobs) and [Configuring Scheduler Jobs](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/configuring_new_jobs) section of the Scheduler Administration Guide. In addition to this, you could refer to [Stored Procedures](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures) for more information on on stored procedures. If you still need further assistance and if you are a valid support user, you can raise a [Support Case](https://support.denodo.com/cases/add), for further assistance from the Support Team. Hope this helps!
Denodo Team
13-10-2023 08:47:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here