What should they be: view or virual models?
by Paul Nittel
Some time, way back in the MetaMatrix days, we changed our nomenclature to refer to "view" instead of "virtual" models. I see the word "virtual" creeping back a bit. Personally, I prefer "virtual" since "view" can be verb-ish. Yes, they are kinda like views in the database world.
Anyway, Jopr lists these models as "virtual". Is that politically correct?
Sent from my Fedora laptop :-P
-------
Paul Nittel
JBoss Sr. Quality Assurance Engineer
Red Hat, Inc.
314-336-2907 (81-62907)
Delivering value year after year.
Red Hat ranks #1 in value among software vendors.
http://www.redhat.com/promo/vendor/
10 years, 5 months
Re: [teiid-users] Are there newer versions of the SalesForce connector for 6.2?
by John Doyle
Hi Mike,
The 6.2 versions of the connector and importer are built against version 15 of the API. There were changes in version 16 of the API that make 6.2 incompatible with version later than 15. The forthcoming release is built with version 17 of the API.
The URL that you see in the importer for version 10 is just an oversight, the value was never updated when we moved from version 10 to 14. There is also a JIRA on the validation issue. (https://jira.jboss.org/browse/TEIIDDES-418) The reason you get the NPE is because this defect allowed you to click Next if you attempted to revalidate after a failed validation.
Not to insult you, I don't know your level of knowledge about SalesForce, but I assume you have a salesforce test instance? The importer and the connector will by default connect to the standard SalesForce URL if you don't supply a value in that box. I suggest allowing the importer to connect to the default URL as a first step just to ensure that your install is in good shape. If that succeeds, than try it with the 15 version of the test URL, but I can't say that it will work. The SalesForce API doc for version 15 of the API still list https://test.salesforce.com/services/Soap/u/10.0 as the sandbox URL.
Also, ensure that you're using password+securitytoken as your password.
As far as supporting the Enterprise API, it's something that I considered when initially implementing the SF solution for Teiid, but decided upon the Partner API. What do you consider the advantages of the Enterprise API?
~john
----- "Mike Mascari" <mascarim(a)yahoo.com> wrote:
>
>
> A few additional notes:
>
> 1. The default Teiid URL is the Partner API 10.0 URL, and the below is the Enterprise API URL (which would be really cool if supported by Teiid), but using the Partner API URL fails as well, including trying to interoperate with versions 10 and 14.
>
> 2. Just to ensure that the SalesForce config works with other products and earlier Partner API versions, I used Mule ESB's SalesForce support (via its salesforce-partner-14.0.jar) to authenticate and query the set of contact records without issue.
>
> - Mike
>
>
>
From: Mike Mascari <mascarim(a)yahoo.com>
> To: teiid-users(a)lists.jboss.org
> Sent: Wed, June 9, 2010 8:45:38 PM
> Subject: [teiid-users] Are there newer versions of the SalesForce connector for 6.2?
>
>
> I though I might give teiid a trial run with SalesForce, so I:
>
> 1. Installed Eclipse 3.4.2 (Ganymede)
> 2. Downloaded teiid_designer_6.2.0.v20090922.zip
> 3. Followed the docs, installed the software, restarted eclipse
> 4. Created a new Metadata Modeling -> Model project
> 5. Choose Import -> Metadata Modeling -> Salesforce as Relational Source Model
> 6. Supplied my Username and Password
> 7. Clicked "Override Connection URL" and supplied the test url:
>
> https://test.salesforce.com/services/Soap/c/18.0
>
> (which I note is eight versions higher that the default Teiid url)
>
> 8. Click Validate Credentials and get:
>
> No operation available for request {urn: partner.soap.sforce.com }login
>
> 9. Click OK to dismiss the dialog
> 10. Click Validate Credentials again (for giggles), "Next ->" button becomes enabled
> 11. Click Next ->, get:
>
> Exception gathering salesforce metadata: java.lang.NullPointerException
>
> 12. Checked the <workspace>/.metadata/.log for any stack traces, but didn't find anything.
>
> Any tips on how to proceed?
>
> - Mike
>
>
>
>
>
>
> _______________________________________________ teiid-users mailing list teiid-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users
10 years, 5 months
7.0 CR2
by Steven Hawkins
Hello all,
7.0 CR2 is available. This candidate release has greatly improved Reference, Admin, Quick Start, and Developers Guides - all are also now included in the download. Support for blob<->clob conversions was added with the to_bytes and to_chars functions [1]. The final release will be coming soon. Let us know if you find any issues.
Check it out - http://www.jboss.org/teiid/downloads.html
[1] https://jira.jboss.org/browse/TEIID-1021
The Teiid Team
10 years, 5 months
Teiid 7.0 Release Update
by Ramesh Reddy
Small change in plans..
We are making significant progress on documentation and some other
issues, however we are not completely finished these tasks yet, so we
are delaying the final release of Teiid 7.0 little bit.
We will hopefully release "Teiid-7.0-CR2" tomorrow and assess the final
release date. Another thing to consider is Designer tooling is still
behind with their updates. We need to make sure that all the APIs and
utilities are defined for them to successfully integrate Teiid 7.0 into
Designer.
Sorry for the delay, but mean while enjoy the last (part5) article in
the "JCA Container Integration, Why Teiid Needs it?" series
http://teiid.blogspot.com/2010/06/jca-container-integration-why-teiid.html
Thank you.
Teiid Team.
10 years, 5 months
Dynamic VDB Support Expanded
by Ramesh Reddy
In the previous releases of Teiid, only "JDBC" and "Text" connectors can
be used in the Dynamic VDBs, as these were the only two connectors that
were aware of their metadata for data integration.
In Teiid 7.0, with the latest changes from SteveH for the XML
Translators and resource adapters, now all the Translators are metadata
aware, except for LDAP (we are still working on this one). So, now you
can integrate data from all data sources that Teiid supports using the
Dynamic VDB feature.
This marks a very important first milestone towards the breaking away
the implicit dependency on Designer tool for building the VDB. Now you
can use the "Dynamic VDB", to do the data integration if it fits your
data integration needs.
However, please note that if you need the abstraction "virtual" layer
above your schema, you still need to use the Designer for building the
VDB as before.
Check out the new examples showing these features in the Teiid download.
Thanks.
Ramesh..
10 years, 5 months
Are there newer versions of the SalesForce connector for 6.2?
by Mike Mascari
I though I might give teiid a trial run with SalesForce, so I:
1. Installed Eclipse 3.4.2 (Ganymede)
2. Downloaded teiid_designer_6.2.0.v20090922.zip
3. Followed the docs, installed the software, restarted eclipse
4. Created a new Metadata Modeling -> Model project
5. Choose Import -> Metadata Modeling -> Salesforce as Relational Source Model
6. Supplied my Username and Password
7. Clicked "Override Connection URL" and supplied the test url:
https://test.salesforce.com/services/Soap/c/18.0
(which I note is eight versions higher that the default Teiid url)
8. Click Validate Credentials and get:
No operation available for request {urn:partner.soap.sforce.com}login
9. Click OK to dismiss the dialog
10. Click Validate Credentials again (for giggles), "Next ->" button becomes enabled
11. Click Next ->, get:
Exception gathering salesforce metadata: java.lang.NullPointerException
12. Checked the <workspace>/.metadata/.log for any stack traces, but didn't find anything.
Any tips on how to proceed?
- Mike
10 years, 5 months
Question on text connector connecting to files remotely located on linux server directory
by Hong Yi
Hello,
I am new to teiid and have been investigating teiid mainly on teiid designer for 3 weeks. I am stuck on a problem I cannot seem to find solution, so asking the list hoping to get some guidance and advice on a possible solution.
Here is my scenario. We have a data collection server (i.e., irods server http://www.irods.org) installed on rdgarchive.renci.org with teiid server also installed there. I know the host name and the directory of source text data files (including text description files) on this linux server that I want to add into teiid virtual database. I have teiid designer installed on another machine. I am able to use teiid designer to add source data model that connects to the text data files locally (i.e., the text data files are physically located on the same machine as the designer) and test the vdb and everything works as expected. However, I am not able to connect to the text files locately on the data collection server remotely. I know I do not have URL string in the text connector written correctly that describes location of the text description file. I tried ssh://rdgarchive.renci.org:11012/to/path/text_description.txt but it did not work. From the connector dropdown list, I see I can use JDBC and ldap connectors, but do not see connectors using ssh or http protocol. Could you let me know whether there is a way to connect to source data files remotely located in a linux server?
Thank you very much for any advice and guidance on this problem.
Hong
10 years, 5 months
