Power Query - Get and Transform connection to Magento Databases Directly

D

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
243
Hello Guys

Has anybody found a way to connect directly to Magento databases to extract data on a read-only connection basis?

I have seen some $600 rip off pieces of software but I am sure there must be a direct connection excel can connect.

I have searched on here and Google with no luck.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

M
  • Question Question
Database Username / Pass for Power Query Connection not saving in Excel workbook
Replies
1
Views
900
ExcelToDAX
E
L
  • Question Question
Excel Power Query Refresh Does Not Update
Replies
2
Views
1K
legalhustler
L
T
  • Solved
Data query connection
Replies
4
Views
604
tcourter
T
C
  • Solved
Help me Convert, Merge and Transpose a pdf table into a singular row, and then repeat that step ad nauseam to create a database
Replies
5
Views
537
Clonk92
C
R
  • Solved
Power Query: Merge Query Where Table 1 Has One Field Matching Two Fields in Table 2
Replies
5
Views
411
rasinc
R

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top