Live data from Hacker News

Redash – Connect to any data source, easily visualize and share your data

github.com

51–60 of 98 posts

Re: Redash – Connect to any data source, easily visualize and share your data

#51
Added the missing Teradata support as the source (kind of) - https://discuss.redash.io/t/teradata-data-source-support/83/...

Waiting to resolve few more --

1) Functionality for CSV/XLS file import , like in Tableau . Some discussion on - https://discuss.redash.io/t/support-csv-data-source/216/5

2) Functionality to select "ALL" in filters

3) Functionality to merge data from multiple data source. I know it does exists in Paid version but waiting for it come in Opensource version.

Re: Redash – Connect to any data source, easily visualize and share your data

#52
post #50
post #46

Do any of the dashboards mentioned support exporting to a report?

You mean as a PDF or email?

Yes, essentially. An export to a file on a given time period would be fine, can deal with the format conversion etc myself. I'm thinking of sending arbitrary reports to management without the need for Jasper etc.

Re: Redash – Connect to any data source, easily visualize and share your data

#53
post #38
post #4

Hello, it seems that there are no instructions on step-by-step installing redash in your own server. The only thing I could find was info on how to install it on AWS or using docker ( https://redash.io/help-onpremise/setup/setting-up-redash-ins... ). However I want to install it normally, using my server's nginx / postgresql / python / supervisorctl etc. Can it be done? Can you provide some step by step instructions…

(Redash author) Step by step instructions could be great, but there is that much time in the day, so figured that anyone who wants to customize the deployment, will know how do it on his own (or use the bootstrap script for reference). I'll be happy to answer questions on how to set it up in your environment, you're welcome to the forum[1], Gitter[2] or Slack[3]. [1] https://discuss.redash.io [2] https://gitter.im/ge…

Thank you very much! I'll try using the bootstrap script and come to slack if I encounter difficulties. Best regards!

Re: Redash – Connect to any data source, easily visualize and share your data

#54
post #52
post #50

Earlier quoted context omitted.

You mean as a PDF or email?

Yes, essentially. An export to a file on a given time period would be fine, can deal with the format conversion etc myself. I'm thinking of sending arbitrary reports to management without the need for Jasper etc.

We are currently working on solving this exact same problem, developer friendly report automation sans visualization. We are entirely focused on solving the reporting problem before tacking visualisation etc. If you are interested in trying out our product, please send me an email at abhyrama at google email service and I will send you the instructions to try it out. The product is out and is being piloted in two large startups which have seen tremendous efficiency improvements in their whole reporting process. We are yet to bring the product public website up.

Re: Redash – Connect to any data source, easily visualize and share your data

#55
post #38

Earlier quoted context omitted.

(Redash author) Step by step instructions could be great, but there is that much time in the day, so figured that anyone who wants to customize the deployment, will know how do it on his own (or use the bootstrap script for reference). I'll be happy to answer questions on how to set it up in your environment, you're welcome to the forum[1], Gitter[2] or Slack[3]. [1] https://discuss.redash.io [2] https://gitter.im/ge…

Thank you very much! I'll try using the bootstrap script and come to slack if I encounter difficulties. Best regards!

Just don't run the script as is on existing server. It's designed to run on a vanilla server.

Re: Redash – Connect to any data source, easily visualize and share your data

#57
post #52
post #50

Earlier quoted context omitted.

You mean as a PDF or email?

Yes, essentially. An export to a file on a given time period would be fine, can deal with the format conversion etc myself. I'm thinking of sending arbitrary reports to management without the need for Jasper etc.

Exports to CSV or Excel are already available. In future releases we will add support for full reports with visualizations and everything.

It's actually already possible with some scripting and our API, but I want to add it into the product itself.

Re: Redash – Connect to any data source, easily visualize and share your data

#58
post #22

Ask HN: Is there any open source BI tool that is always first on the list when the conversation finally gets to "Oh, you're on the Windows/Microsoft stack? Then you're probably going to wind up using _______"

I think part of the reason this happens is Java has wider support out of the box for most data sources via JDBC than Windows has with ODBC/ADO.NET. I mean, it's a close race, but most new open source databases have Java/JDBC drivers first and then ODBC second, for example. I think this may change a little with .NET being opened and cross platform, but it might take a while.

Of course you can make Java/JDBC connections from Windows to databases but many users somehow find it more difficult and I've noticed an annoying trend among large enterprises running Windows on the desktop to not want to support Java/JDBC tools on the desktop, unless they are invested in it.

Re: Redash – Connect to any data source, easily visualize and share your data

#59
post #48

I really like Redash, it’s one of the early tools that introduce this concept of turn SQL into chart to developers, and also teach developers to learn and write better SQL, altogether without any cost. I evaluated Redash during my past company back in 2013 (we were also using Tableau), but due to some Redash’s lack of features (no support for filters, lack of permission control, sporadic performance), we went and bui…

Hello! Redash is great if you are looking to host it in-house and have the engineering resources to set-up and maintain it.

If you are looking for an affordable SaaS alternative, you may want to look into Holistics (www.holistics.io). (Note I'm the other co-founder here with huy)

Besides supporting native SQL, Holistics is designed to address the gaps of SQL for common business reporting use-cases (flexible way of passing user inputs as parameters into report query; supporting if-else capabilities in SQL, reusable query templates and records/columns based access control for users/user groups).

This makes it easier to manage and reduce the management of duplicate SQL query syntax across multiple reports/dashboards (especially multiple UNIONS/Case-Ifs statements). We also have our own DSL for you to configure in more details how certain charts should look like (beyond the normal coloring).

A common problem we also see is that most data-related work is not just visualization, mainly for the reason that most data are not structured/formatted in the right table structure as most companies start off without a data warehouse.

While most query tools requires customers to work with a separate ETL/warehousing tool, we’ve built an integrated approach towards data reporting and data preparation. Insights from our data reporting module (reports with expensive joins, long query times, non-optimal table structures) provides your data analyst inputs to easily move, map records, and transform data without technical engineering knowledge. Data in Google Sheets or CSVs with their data sync automatically (incrementally or full) to their database.

And all this is done with the data not leaving our customers’ database (we don’t warehouse their data. Our data reporting module works directly with your database, and our data preparation module provides just the utilities (not infrastructure) to automate your data pipeline process.

Do take some time to check us out! Quote HN and we give you an additional one day of free trial! :P

Re: Redash – Connect to any data source, easily visualize and share your data

#60
post #41

For those of you looking for a another fully hosted solution, check out https://www.cluvio.com (full disclosure: I am one of the founders). Like redash, Cluvio allows you to run SQL queries against your database and quickly visualize results as beautiful, interactive dashboards, which can easily be shared within your company or externally. We developed our own custom grammar on top of SQL which makes writing time-ran…

Hey Maarius, thanks for chiming in! I've had my eye on Cluvio for a while so I was gonna drop it in here to ask how the two compare.

For me, an open source core is a huge gesture of trust though. It's the ultimate "no lock-in strategy" guarantee. This business model has been proven sustainable by several SAAS companies, such as Automattic (WordPress.com), Discourse (which I work for), Sentry, Piwik and hopefully Redash well!

Any chance Cluvio will consider going down this path too?

Post reply on HN