With a north facing window in a northern climate you effectively have no outside light source as far as cacti are concerned. Your primary light source must be artificial and lots of it.
Check this answer. It's about moss but the light requirements are the same.
This gardener is having good luck indoors with "a 50W HID lamp (directly above this plant), and a 150W HQI lamp".
This question about growing chili peppers indoors is also relevant.
To sum up, you need:
- lots of light
- positioned close to the plants
- if you use HID lights you will probably need a fan to distribute the heat
- a mixture of HID, fluorescent and high pressure sodium will work
- be prepared for the electrical bills as the lights should be on about 16 hours a day
- for HID or high pressure sodium they draw a considerable amount of power. Ensure that your household circuitry can take it.
- cheapest and coolest solution is lots of fluorescents suspended twelve to eighteen inches from the plants but this will not match the light output of the other types
- LED lights do not seem to provide enough illumination