Forum Discussion
i want get the data from the database
i want to import data from the database into excel.how can i do itt
3 Replies
- Hi Yunyun, You can use any free SQL Client applications like DBeaver, dbForge etc.
- Manjunath_Suryanarayana
Microsoft
You can use Azure Data Factory service and build a copy activity which supports PostgreSQL as source and Excel file (stored on Azure Blob Storage) as sink. The following documentation should help you:
For excel format: https://docs.microsoft.com/en-us/azure/data-factory/format-excel
for PostgreSQL as source: https://docs.microsoft.com/en-us/azure/data-factory/connector-postgresql?tabs=data-factory yunyun You have two choices. Install an https://www.bing.com/ck/a?!&&p=dbd9a24b81221bf9be172f01e17e2573b0888f3d618fdc5d525e9e2e64621936JmltdHM9MTY1NDE3MTYyNSZpZ3VpZD1mN2VhNWIzMy1kNWJmLTRmMjAtODVjYy1kMzdjOGVkZDg2YmUmaW5zaWQ9NTE3Mw&ptn=3&fclid=84d8c959-e26c-11ec-ade7-3ddf2f9d0b1f&u=a1aHR0cHM6Ly9vZGJjLnBvc3RncmVzcWwub3JnLw&ntb=1 for PostgreSQL and then follow the https://www.bing.com/ck/a?!&&p=7a0bb69c3f5811109f90f4180fbc1e29d6db4c12371f9069ef39406d9a10aa36JmltdHM9MTY1NDE3MTY1MyZpZ3VpZD0yZmVmZDFjYS1kNjQ2LTQzOTktYWZhMC0xNzhjYjJiZjVkODMmaW5zaWQ9NTI0NA&ptn=3&fclid=955e7428-e26c-11ec-ab79-c93e22a6d4f3&u=a1aHR0cHM6Ly9kb2NzLm1pY3Jvc29mdC5jb20vZW4tdXMvc3FsL2ludGVncmF0aW9uLXNlcnZpY2VzL2ltcG9ydC1leHBvcnQtZGF0YS9jb25uZWN0LXRvLWFuLW9kYmMtZGF0YS1zb3VyY2Utc3FsLXNlcnZlci1pbXBvcnQtYW5kLWV4cG9ydC13aXphcmQ&ntb=1. Install a PostgreSQL driver and follow the https://support.microsoft.com/en-us/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a?redirectsourcepath=%252farticle%252fbf941e52-066f-4911-a41f-2493c39e69e4 path. Only real trick is ensuring that your firewall allows the IP address where Excel is attempting to connect from. That's it. Connection string is just off your URL, available from the console. Login and password are whatever you define.
