Joseph Buko
Technical User
Hello all - just curious if there is a way to connect to your mymicros.net database server? Whether it is through excel, SQL, or other sources. I would just like to be able to access the raw data.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connect MYMicros through SQL or other database server. 1
- Thread starter Joseph Buko
- Start date
- Status
-
1
- #2
FreeSoldier
Technical User
There is an Excel plug-in called iquery that you can download from mymicros.net. It allows you to do quite a few query via a GUI and acccess multiple data set. But it it is not a full fledge access to the raw data.
Good luck
Good luck
Joseph, are you talking about the self-hosted MyMicros used by Simphony, or are you talking about the cloud hosted MyMicros used by the other platforms?
If it is cloud hosted, then no, you can't connect to the SQL server directly. If it is locally hosted, yes you can connect to the data server, which is either going to be a Microsoft SQL server or an Oracle database.
If it is cloud hosted, then no, you can't connect to the SQL server directly. If it is locally hosted, yes you can connect to the data server, which is either going to be a Microsoft SQL server or an Oracle database.
- Status
Similar threads
- Locked
- Question