Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect my dot net application to essbase.

Hi all;
I am developper and i want to connect my application to essbase database. This the code I have:

string connectionString = string.Empty;
connectionString = "Provider=MSOLAP;Data Source=http://192.168.24.4:19000/aps/XMLA; Initial Catalog=MaBase;User Id=admin;Password=admin123;Timeout=60000;";

  string query = "SELECT ...";  
  AdomdDataReader reader = null;   
  try  
  {  
    using (AdomdConnection conn = new AdomdConnection(connectionString))  
    {  
      conn.Open();  
      using (AdomdCommand cmd = new AdomdCommand(query, conn))  
      {  
        reader = cmd.ExecuteReader();  

        while (reader.Read())  
        {  
              Console.WriteLine(reader.GetString(0));  
          Console.WriteLine(reader.GetString(1));  
        }  
        Console.WriteLine("fin");  
      }  

    }  
  }  
  catch (Exception ex)  
  {  
    Console.WriteLine(ex.Message);  
       
    throw;  
  }
Comments