-
1. Re: how to write data using TEIID
shawkins Apr 24, 2013 9:10 AM (in response to mbisne)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
-
2. Re: how to write data using TEIID
mbisne Apr 24, 2013 10:01 AM (in response to shawkins)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
-
3. Re: how to write data using TEIID
rareddy Apr 24, 2013 10:41 AM (in response to mbisne)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..
-
4. Re: how to write data using TEIID
mbisne Apr 24, 2013 10:46 AM (in response to rareddy)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
-
5. Re: how to write data using TEIID
rareddy Apr 24, 2013 11:12 AM (in response to mbisne)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..