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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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
926
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
623
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
574
Clonk92
C
R
  • Solved
Power Query: Merge Query Where Table 1 Has One Field Matching Two Fields in Table 2
Replies
5
Views
439
rasinc
R

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,623
Latest member
Techenthusiast

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