This article explains how to connect your Microsoft SQL database to Magento BI in a four-step process. This process requires some technical expertise related to server connections and SQL, and may require support from developers on your team.
We support Amazon RDS, EC2, Microsoft SQL Azure, and most other cloud server providers. If you have a question on your particular host, please email us at firstname.lastname@example.org.
Our system needs to run SELECT queries on your database. We do this initially to get a snapshot of your database structure, and then regularly over time to keep our data up to date. Our updates are incremental, and we restrict update frequency and time to prevent any unwanted load on your server.
The best way to do this is for us to connect to your database server over TCP/IP. Create a user for us that can only run SELECT queries (and, optionally, can only select data from the tables you specify). This needs to be done for each of your servers that you will be connecting to Magento BI.
Log into Magento BI and go to Manage Data > Connections in your sidebar (only admin users have access to this page).
Then, click the "Add a Data Source" button. Select to connect a Microsoft SQL database and enter your credentials in the fields on the new connections page. Please note if you are using Windows Azure, you must specify a database name as well.