Hello everyone,
Can someone please help me with my below query.
I will upload excel sheets in confluence. can you please suggest how I can get access these files and insert them into SQL?
I would not upload them to Confluence. There's nothing in Confluence that could read data out of a sheet and push into another remote database, you'd need to find or write apps to do that.
It would be far easier to write something that can push your excel data directly into your database,, no need to use Confluence at all for this.
Thank you Brough for your response.
My team members are using confluence to share the data(excel sheet). I am looking to create SQL queries and dashboards out of it.
Can you suggest what is the best method I can follow.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would download the files from Confluence, and write something in excel that generates the SQL you need from it, and then executes it in your remote database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.