Dear developers,
I am asking if you have already experienced this request.
A client has a need to open from Asana an SQL view generated by another software (in this case SAP Business One).
I would like if I can have a task or a message that enables an Asana user to view a SQL query result into Asana?
I would need to connect it with an open API I assume ?
At present there is no supported way to integrate directly into the Asana UI, so the only way I can think of to run a query or open a view would be to have a link in a task’s description that somehow ran an external app which did the query and displayed the result on-screen. Not a very clean solution, but it’s all I can think of.
If someone else has a better idea, please chime in!
Thank you so much Phil!
I am open to hear any other idea about the issue.
Otherwise I will tell the client that we should receive in Asana a link in the task that enables us to display the result, in another app or website.
I think of using tray.io to connect Asana with SAP, have you already used it as well?
Thanks.
I thought about maybe mentioning a service like tray.io or automate.io - I didn’t because my impression is they are more about adding single tasks more than querying existing data - but no, I haven’t used either of them so I can’t say for sure. Yes, I would say you should explore those as options.
I am trying to Connect asana to SAP analytics cloud. Do you know how to do that?
I don’t know but I think you’ll need to use a third-party tool like tray.io unless you write code to do it yourself using Asana’s and SAP’s APIs.
Hello,
I am an experienced SAP consultant, but not a specialist in Analytics Cloud.
SAP has APIs yes, but why do you want to connection?
real-time data integration? periodic reporting?
depending on the need that you have, the way you will integrate it might be different.
Happy to discuss further.
1 Like
Hello,
You can use Asana’s API to create custom solutions that fetch data from your SQL view and display it in a task or comment. You’d need a middleware service to connect SAP Business One’s SQL data with Asana, such as a script or a service running on a platform like AWS Lambda.
Or try a no-code alternative. If coding a custom solution doesn’t work for you, tools like Skyvia can simplify the process. It is a no-code platform that enables you to query SQL databases and integrate results with platforms like Asana. You can get more information here.