how to write data using TEIID

[mbisne]

Hi,

I wanted to know, how to write data from text file or database to a database using TEIID.

Cheers,

Mandar

[shawkins]

Assuming that you are using Teiid Designer your basic steps are to create models of the databases via an import of the their metadata - see https://community.jboss.org/wiki/HowToModelJDBCDataSource

You will then also need a file source - https://community.jboss.org/wiki/ConnectToAFlatFileUsingTeiid

From there writing to the target database will simply be through insert statements.

Steve

[mbisne]

Thanks Steve for your reply.

I am using Teiid Designer. I have done all the steps mentioned in the Document( the link which you have specified above).

I have created the VDB also.

So I am confused on how to insert data in the database ( as in the Physical Database).

Where should I fire my INSERT statements.

Cheers,

Mandar

[rareddy]

Mandar,

Same place where you are fire your "SELECT" statements. i.e. if you are writing a application on top of the Teiid VDB, that is where you issue those SQL commands. I suggest you get yourself familiarized with SQL http://www.w3schools.com/sql/ and JDBC http://docs.oracle.com/javase/tutorial/jdbc/basics/

Ramesh..

[mbisne]

Thanks Ramesh for your reply.

I am firing my SELECT statements on the virtual database.

How can I fire my INSERT statements there (virtual database)?

Cheers,

Mandar

[rareddy]

Mandar,

The correct term to use is "issue" or "query" to let's stick to them rather than using "firing" sounds we are killing somebody

Now, how are you issing the "select" statements against the Virtual database(VDB)? If you are using the Teiid Designer, are you using the "preview" feature? Or you are using "Data Tools" perspective to connect to the VDB? If you are using "Data Tools" perspective, you can enter the SQL statements in the window it provides and execute them from Designer.

Typically once somebody develops a VDB, they deploy to the VDB to a Teiid Server, then connect to it using JDBC/ODBC from a client application and then "issue" any SQL statements against the VDB, just like you may done with other databases like Oracle. If you are not familiar with SQL, I gave a link in above post. If your client application is Java based, then you need to use JDBC to connect to the VDB, I have provided a link. If you application is .net based, then use the ODBC to connect to VDB.

Hope this helps.

Ramesh..