Is it possible to create a virtual SQL table?

CloverDX Platform
1

Hi,

My subject could be seemed strange. Maybe it’s normal, I’m new user of the ETL Tools. I’d like to create a virtual table with an existing table. I’m going to descrive more.

I have a program that makes requests to a SQl DB. However, I’ve a different schema with my SQL DB and of course, I can’t use the programm with my DB. What I can do is only create a virtual DB that’ll use the right schema but in using the data of my SQl DB. It’s a kind a add-on on my SQl DB.

I don’t want to only extract my data in a right schema. I want to keep my DB.

Is it possible to create such virtual table?

Maybe, you’ve an another solution at my problem?

Thank you,

Best,

Bat

2

Hello Bat,
I’m not sure if I understand your problem, but I believe, that you are looking for database view.
With Clover you can read data from database and store them somewhere else (in another database or file). If the table has a primary key (or another column, that can identify new records), you can use incremental reading feature (see incrementalKey and incrementalFile attributes of DBInputTable) for reading only not-read records.

3

Hello,

It’s not really what I want. I need to have, of course, a view of another database, and I need also to create a virtual DB. It means that with this virtual DB, I have an new URL for the DB, and I’ll sand my request at this URL. And then, this news DB’ll check and write in another DB…

Like somehting that you put above an existing DB…

4

Hello,
I’m sorry, but I still don’t understand your request. Can you write a concrete example of the job? Eg. select and insert/update queries with source, target and mid-point databases.

5

I can’t write a sample because I don’t know CloverERL…

Take an example. I have a program that uses a SQL DB an I want use this program with another SQL DB with another schema. I understand that I can export the different SQL DB in the right schema. But I don’t wanna do this.

I want create a “empty” SQL DB and when the program’ll make a request, this “empty” DB will send a query to the wrong SQL DB. It’s a kind of intermediate DB, located front of the bad schema SQL DB.

Is it clear enought?

6

Hi Bat,

From your description, it looks like you are looking for some kind of logical layer on top of physical DB (single or more). Clover ETL’s main purpose is to work with physical databases where you can read data from tables, views or even stored procedures. The same for writing. But there is no ‘virtual’ layer over database(s) provided.