Likelihood to Recommend
I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.
Read full review
TIBCO Data Virtualization has developed a platform to track, manage, and provide concise reports throughout the various stages of the sales process. It is a powerful tool that has helped maximise efficiency through its visualisation formats. After working with this tool and seeing the benefits, I couldn't imagine my life without it. I will continue to use TIBCO Data Virtualization for the foreseeable future.
Read full review Pros Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources Snowflake manages concurrency better in our trials than other premium competitors Snowflake has little to no setup and ramp up time Snowflake offers online training for various employee types Read full review Connecting to different data silos and presenting the data as a singled unified layer of data. Exposing data to Technical and non technical users through Web UI or reporting tools Secured exposure of data as web services. Row level and column level data security Multi tenancy data security. Real time data by connecting to the operational databases Historical data generation Read full review Cons This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team. I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot. Read full review Performance of TDV Studio (its own IDE) is poor. Performance of TDV repository database is rather poor for larger numbers of objects .(Note: We have approx. 9tsd objects introspected in TDV and approx. 20tsd objects generated in upper DV layers.) Propagation of privileges to parent/child dependencies does not work when applying recursively on a folder. (It's a huge setback when working with large number of objects organized semantically into subfolders.) Lack of command line client interface for scripting at the time of version 8.4 (I had to write my own CLI.) TDV Studio does an absolutely horrible job with its own code editors when indentation is in place. Also, the editor is brutally slow and feature-poor. Tracking privileges on the level of table/view columns causes occasional problems when regranting. TDV's stored programs ("SQL scripts" in their own terminology) compiler leaves out many syntactic and semantic checks, making them hugely prone to run-time errors. TDV Server's REST API is a very poor (in terms of features) and flawed cousin to its SOAP API (at the time of version 8.4). Read full review Likelihood to Renew
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Read full review
It is useful for us to see the data and do analysis. Also we use it to generate reports and see trends or gather insights
Read full review Usability
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Read full review
It has a drag-and-drop feature and a good list of data adapters which makes it easy to thread across elements of various data sources.
Read full review Reliability and Availability
We have never encountered issues where it was unavailable when we needed it.
Read full review Performance
TDV does integrate with a host of third-party apps such as BO/ Spotfire for reporting, Informatica for ETL, etc. However, if it can come up with its own suite of these products and combine features of TDV into a single robust Data Integration/ Analysis/ Reporting software, then it is more likely that people will want to explore the product more.
Read full review Support Rating
We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.
Read full review
On a few occasions I have asked TIBCO technical support for help because I have adapted perfectly to their tools, but in those few that I have communicated with their technical team I have received personalized, attentive, responsible attention and I am always assisted by an expert staff the topic. A TIBCO technical support technician spent more than an hour helping me to solve a problem in the initial stage of implementation in my department and this is something that I always appreciate.
Read full review Online Training
The training was helpful. I was able to understand how to use TIBCO for the data load process that we implemented and how to perform various troubleshooting steps based on the training I received. The technician was thorough and took the time to answer any questions. Once we were shown how to use TIBCO in the test environment, we were able to configure the production environment ourselves.
Read full review Implementation Rating
Other vendors have clearer, more visual implementation documentation. We also did not have our data architect and and server administrator available full-time for implementation. In the future, we will secure the necessary internal resources.
Read full review Alternatives Considered
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.
Read full review
We did not need to evaluate another technology in the same category for data virtualization, since we are 100% sure of the capabilities and benefits that we would have with TIBCO Data Virtualization, both for market positioning as well as success stories from other companies. great renown worldwide. From the first day of use, it meets our needs to provide the expected solutions.
Read full review Scalability
It seems to be flexible and scalable based on our needs.
Read full review Return on Investment Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters. Read full review We took spreadsheets that took hours a month to update and made them update automatically using TDV, saving hours a month of analyst time The incremental cost of TDV relative to straight spotfire licensing made it a no-brainer due to the ease of data management We continue to automate legacy business processes in TDV, saving time all over the organization. Read full review ScreenShots TIBCO Data Virtualization Screenshots