AutoCAD MAP3D and Microsoft SQL Server: 3. Create a New Map System User

It was long time I post last tutorial of this series AutoCad MAP3D and Microsoft SQL Server. In this part I gonna to write how to set up you first industry model on new installation of MS SQL Server. If you do not know how to install MS SQL Server just read my previous article.

1. OK, what's next? Aah. Firstly you need to open a little application usually located in your Infrastructure Administrator bin folder. OK! You asked where is that folder? It is here on my computer: C:\Program Files\Autodesk\Autodesk Infrastructure Administrator 2013\bin\, If you install your AutoCad MAP3D normally way and you did not change anything, you should have it on a same location. In this folder you can find a little application called Autodesk.IndustryModelSetup.exe.
2. After you start this app, you should change a "Industry model type" drop-down menu from Oracle Database to Microsoft SQL Server. The easiest way to log in is to use Windows Authentication mode and fill out server name. This server name is in my case VIRTUAL-PC\SQLEXPRESS. If it is installed on local PC, it should be NAME_OF_YOU_PC\NAME_OF_SERVICE. [[You can find out the name of service by pressing Win-Key+R and then write into text box services.msc and hit OK. In list of services, you should find a text like this SQL Server (SQLEXPRESS), in parentheses you usually find name of your server. ]] After you fill out the name of your server, press Next button.
3. After pressing next, you should be on step number two: Manage System User:
   
4. It is obvious that you do not have a Map 3D system user installed. How to set it up? Isn't it so obvious? Just press Create button and fill out the name of your new Map 3D user. Mine will be called MAPSYS2013:
   
   
5. And waaaaaait................................... because the Creation process is running...
6. And now you successfully installed your new Map System User.
   
7. You can see that Map 3D system user is Installed, your Map 3D Server Version is Autodesk Industry Model 2013 and Map 3D Version is Autodesk Industry Model 2013 as well.
8. Just close this Industry Model Set Up application and start Autodesk Infrastructure Administrator. And press Connect to enterprise database icon or go to menu Enterprise and press Connect to enterprise database as well
   
9. Then press "Options":
   
10. Fill out Map 3D System User part. I believe you know what to select and write into text boxes.
    
11. And press Connect...Yeah, You are loged in... Great job.
    
    
    
    Next tutorial we will show how to create new Enterprise user. Thank you for reading...
    
    
    Please comment if it helped you...

Circle polyline in Oracle?

Did you ever want to create a circle polyline to Oracle spatial datatype SDO_GEOMETRY? I did! But I had a little problem - I had only to vertices. The problem is this:
If you want to create polyline circle in Oracle, you need to create two opposite arcs. And if you want to create two arcs you need to know three points, because each circular arc is in Oracle described using three coordinates: First is the arc's start point, second is any point on the arc, and the third is the arc's end point.
This SQL-script should provide you the way to create a polyline circle from two vertices laying on the circle:

select mdsys.sdo_geometry(2002,YOUR_SRID,null,mdsys.sdo_elem_info_array(1,2,2),mdsys.sdo_ordinate_array(
X1,Y1, --Vertex number 1
(X2 - X1) / 2 + X1 + (sqrt(power(X2-X1,2) + power(Y2-Y1,2))) / 2 * cos(atan2(Y2-Y1,X2-X1) + 3.141592653589793/2),
(Y2 - Y1) / 2 + Y1 + (sqrt(power(X2-X1,2) + power(Y2-Y1,2))) / 2 * sin(atan2(Y2-Y1,X2-X1) + 3.141592653589793/2), --Vertex number 2
X2,Y2, --Vertex number 3
(X1 - X2) / 2 + X2 + (sqrt(power(X1-X2,2) + power(Y1-Y2,2))) / 2 * cos(atan2(Y1-Y2,X1-X2) + 3.141592653589793/2),
(Y1 - Y2) / 2 + Y2 + (sqrt(power(X1-X2,2) + power(Y1-Y2,2))) / 2 * sin(atan2(Y1-Y2,X1-X2) + 3.141592653589793/2), --Vertex number 4
X1,Y1  --Vertex number 5
)) from TABLE_WITH_VERTICES

That's it! Keep drawing... :)

AutoCAD WS - the service of the future?

AutoCad WS is free online CAD program providing great opportunity to present and view dwg drawings! You can use your web-browser, iPhone and iPad, Android as well as iMac to work with AutoCad WS.

Environmental and consulting company Rindt-McDuff uses AutoCAD WS in conference calls so they can reduce paper and printing costs. Source: www.autocadws.com

I have few ideas where you can find this great peace of software use:

• You can visualize your ideas on the field.
• You can have very fast and practical dwg viewer,
• In my opinion this app is a great opportunity to impress your customers, 
• You can provide drawings to customers who do not own desktop application AutoCad.
• You can save money for printing
• It is much more sophisticated way to share your ideas
• and others...

I think AutoCad WS is at least worth of its cost :) Because its price is ZERO! Just visit it here www.autocadws.com or find it on your Android Market and App Store.

Share your ideas how to use this practical piece of software...

Historical maps of Austria-Hungary empire

Historical maps are fascinating. You can see how people were thinking, you can see history, partly growth of villages, towns and cities, when you compare it to nowadays.

AutoCAD MAP3D and Microsoft SQL Server: 2. Installation of Microsoft SQL Server 2008 R2

 Let's install MS Server which we downloaded in the past blog-post. I have to repeat again and again, ensure yourself that you downloaded Microsoft SQL Server 2008 R2 SP1, because Auto-CAD MAP3d supports only this version!

AutoCAD MAP3D and Microsoft SQL Server: 1. Download MS SQL server

AutoCAD MAP 3D, the GIS application, now supports not only ORACLE server, but Microsoft SQL Server as well. This is great steps for Autodesk and for us, users, either. Users now can work with enterprise industry models on SQL Server, with more powerful and enhanced FDO provider, as they could use it with Oracle systems before. Let's take a few steps forward.
I hope, you can do it! :)

So question is: How to download installation file for Microsoft SQL Server?

TIP: Draw polyline in AutoCAD from entry in ORACLE

Sometime you just need to draw complicated polyline with lot of vertices in AutoCAD (possibly MAP 3D), but you have all you coordinates saved in attribute with data type SDO_GEOM.