You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for Cloud Databases great and have the most points for this month!
I keep getting the following error. The tns is in my tnsname. What am i missing?This is from Toad for Cloud Database tool.Got error 4206 'Invalid data source definition: ORA-12154: TNS:could not resolve the connect identifier specified' from HUB
I have installed Toad for Cloud databases for Salesforce. I am able to browse the schema and run standalone queries on the SQL pane but I cannot get the visual query builder running.
By query builder I mean the visual drag and drop and join that I was able to do in previous versions of TOAD. Is this feature not available in this version?
I'm getting the follwoing error when trying to map a data source; any idea what this is?
"Error mapping data source "SFDC" for Data Hub "Embedded Data Hub".Got error 4200 'SAXParseException' from HUB"
"A Data Hub error occurred while mapping the data source "SFDC".:java.lang.RuntimeException: Error mapping data source "SFDC" for Data Hub "Embedded Data Hub".
at com.quest.toad.cloud.explorer.dialogs.MapDataSourceDialog.okPressed(Unknown Source)
at com.quest.toad.cloud.explorer.commands.MapDataSource.execute(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
Caused by: java.sql.SQLException: Got error 4200 'SAXParseException' from HUB
... 44 more
java.sql.SQLException: Got error 4200 'SAXParseException' from HUB
Using SFDC with Data.com. Account, for example, includes DUNS number field. Meta data for all fields of Accounts, including DUNS numbers, is viewable via Partner API queries (using modified version of https://code.google.com/p/plsqlsoap/source/browse/trunk/oracle_sql/OLAP_XMLA_SF_body.sql). But these fields are not available in TCD using Data Hubs->Embedded Data Hub->my_sandbox_data_source->Mappable Objects->Account.
Permissions on the SFDC side appear to be configured correctly. The DUNS number appears on the Account page layout and is viewable by my login. DUNS number is normally read-only, so I made it editable; no change from TCD end. Set it back to read-only.
I would like these fields to be queryable from TCD. Advice?
I'm using toad for cloud, connecting to hive server 1 via ssh.
I have no problem connecting to data, get to see the tables and fields.
I'm able to run a query and get the results.
but after I run a query (for the first time after I open Toad), the second one (and no matter what is the query, can be the same as the first one or different) , returns me the error :
org.apache.thrift.TApplicationException: Internal error processing execute
after this a restart is required for the thrift.
Same queries are running in Hue or with Tableau without problems.
Did anyone have the same problem?
Hi All,I'm just beginning with Toad for cloud databases(cassandra). The point is : When I create a table via cassandra ( cqlsh ) I can find all my tables on Toad and I can manipulate them on Toad . On the other hand, when I create my tables via Toad I don't see them displaying on Toad but I can do a "select" or an "insert into" on these tables.Only tables created via Cassandra are displayed. I would like to know where are spent the tables which I created on Toad. I already refresh the data source, reconnect the data hub but nothing...Thanks a lot.
Does anyone know if there are plans for Hadoop/HiveServer to leverage Quest Authentication Services for Linux. We cannot connect Toad to Hadoop Hive with Kerberos authentication enabled. Thanks
When I try to map some HBase tables with more column families and with number of rows > 500K, Quest Data Hub service crashes. For some tables data hub works fine. Is there any limitations for Quest Data Hub regarding HBase tables?
I added a HBase table as a data source in the Data Hub in Toad for Cloud Database. Can I do operations like SQL trigger for on the mapped HBase data?
Is there any planned date to support Hiveserver2 with Toad?
I setup Toad for Cloud databases and connected to Hbase. When I map Hbase table columns having integer or Boolean values in it, I get null in query result.
I have two SFDC sandboxes.In the first are custom objects with data. I connected TCD, mapped some custom objects to tables, viewed the data and queried the data. All good.In the second are custom objects with no data. I connected TCD, but when I go to map a custom object, TCD lists only the out-of-the-box attributes for an object. The custom attributes are not listed. Proceed to map the object to a table, and the ootb attributes list, but TCD seems to be unaware of the custom attributes. When I query an attribute I can see using SFDC's Schema Builder, TCD say "Unknown attribute... in 'field list'". Each custom object here says "In development/deployed." Why can't I see the custom attributes for these custom objects of the second sandbox?Thanks for any help with this.
Hi, I am connecting to the Hive Server using TCD eclipse plugin and running HIVE QL commands. One question that i had was how do i run multiple queries in one session? What im trying to do is run commands like:add jar jarname;create temporary function blah;select blah(field) from table where date=date;The above two commands and the select have to run before the third select runs, else the select will fail. Basically all the three commands have to run in one session.How can i do that?
Hello,I use ToadForCloud to view SalesForce data. I wonder how to limit result set (rows or percent) in SQLs issued to SFDC.Thanks in advance for your help.Regards,ToadForCloud
I'm using Cassandra 1.2.x release (latest) and download Toad for Cloud Databases. I'm struggling to have Toad connect to Cassandra. The cluster is not local and I am using the embedded data hub. The embedded data hub is connected and I can connect to SQL Server data source just fine. However, when I tried to connect to Cassandra, I'm getting an error. I can successfully connect to the remote Cassandra cluster using CLI/CQL from my local machine. I can connect to the cluster using Cassandra Cluster Admin tool as well, just not with toad. I'm attaching the error screen. Any help will be greatly appreciated.
Hi all! First of all nice job with Toad for Cloud (currently trying it out for Hive).I have a small problem (i tried doing a search but didn't get any results) and it is that when I map tables in the "Embedded Data Hub" from a Hive schema all the BigInt's or any numerical value get's defaulted to integer type which is causing that column to return NULLS in my SQL queries. I know i could map tables individually and give them the type "Real" but when you have a big Schema with several hundreds of tables this becomes a problem. Is there a way for me to default the numerical datatypes definitions into "Real" datatype or if you guys could consider getting the "decimal" datatype as a datatype?Thanks!
I have a problem with Toad for Cloud returning empty result connected to Hive. It displays the column names, but no rows returned. I just installed it. It seems to be connected successfully, since it shows the tables part of the database. The same queries returns rows when run from SSH. It happens trying different scripts run against different tables. Anyone else experienced the same behavior?