How to manually deploy ODC Files to Microsoft Dynamics AX 2009 Enterprise Portal


Sometimes you may come across an issue with deploying ODC files from “AX2009 ->Administration -> Setup -> Business Analysis -> OLAP -> OLAP Administration” for various reasons and you have already tried the suggestions given in this link, then you can follow through the following manual steps to deploy them to the Enterprise Portal Server:
 
1. The ODC files are deployed to the Data Connections page on the Enterprise Portal site. By default, the Data Connections page is located at: http://[your ep hostname]/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx
Verify if the files, definitely do not exist.


2. Download the attached AX2009_ODC_Files.zip and extract its contents to an empty folder. This contains 11 default ODC files.


3. Open the extracted ODC files with Notepad or any other text editor.


4. Edit all the odc files and replace the values in <odc:ConnectionString> to reflect your OLAP Server/Instance name and Database name:


Data Source=[Specify Your OLAP ServerName]


Initial Catalog=[Specify Your OLAP DbName]


ALSO, consider adding SSPI=Kerberos; to the ConnectionString, ONLY if you have configured Role Centers to use Kerbersos Authentication (given in bold below):




<odc:Connection odc:Type=”OLEDB”>
<odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;DataSource=[YourOLAPServerName];Initial Catalog=[YourOLAPDbName];SSPI=Kerberos;</odc:ConnectionString>


For example, if your OLAP Server name is Server1 and the OLAP database name is “Dynamics AX” and you have Kerberos Authentication configured then the <odc:ConnectionString> should look like this:

<odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=Server1;Initial Catalog=Dynamics AX;SSPI=Kerberos;</odc:ConnectionString>

5. Save the changed ODC files.



6. If required, rename the ODC files names to match your OLAP database name, if not using the default database name “Dyanmics AX”. By default the file naming structure is [OLAP Database name][space][Cube name].ODC, and there is also a default .ODC file just named as [OLAP Database name].ODC.
NOTE: The [OLAP Database name] is determined from what is specified in the “OLAP Administration” form under the “OLAP databases” tab (AX2009 ->Administration -> Setup -> Business Analysis -> OLAP -> OLAP Administration)


7. Browse to your Enterprise Portal site main site.


8. Click on Site Actions > Site Settings.


9. Under Galleries, click on Master pages.


10. Click on View all site content (top left).


11. Click on Data Connections folder (or alternatively browse to the Data Connection page, by default this is located at http://ServerName/sites/DynamicsAx/Data%20Connections/Forms/AllItems.aspx).


12. Import all the edited ODC files.


 


REFERENCES:


Unable to deploy ODC files to Enterprise Portal even after installing Hotfix KB960158 (or any AX 2009 Rollup Update 1, 2,3..)


Tips and Tricks Implementing SSRS and SSAS Integration for Microsoft Dynamics AX 2009

AX2009_ODC_Files.zip

Comments (2)

  1. Waldemar says:

    Attention! Are you sure, it is "Data Source" (with space) in your "should look like this"-box?

  2. shan says:

    I tried deploying the odc files with the kerberos addition, but still i got the error. i tried to open the odc file on excel, when i hit the Test Connection it throws error, and when i test connection after removing the SSPI = kerberos, it is successfully. but after clicking ok, i get unable to load list of tables from the datasource

    on my machine sql server 2005 with windows server 2008 . please help me in this regard.

    ——————————-

    This sounds like Kerberos authentication has not been fully setup successfully. Please review the whitepaper http://www.microsoft.com/downloads/en/details.aspx?FamilyID=be720eb3-649a-49ff-b019-a1e4e7af6b47 and our support blogs http://blogs.msdn.com/b/emeadaxsupport/archive/tags/kerberos/.

    –Anup