{"id":80,"date":"2006-08-14T12:29:00","date_gmt":"2006-08-14T10:29:00","guid":{"rendered":"http:\/\/www.forksoft.de\/blog\/2006\/08\/14\/oracle-integration-into-navision\/"},"modified":"2007-11-03T17:32:40","modified_gmt":"2007-11-03T16:32:40","slug":"oracle-integration-into-navision","status":"publish","type":"post","link":"http:\/\/www.navision-blog.de\/blog\/2006\/08\/14\/oracle-integration-into-navision\/","title":{"rendered":"Oracle Integration into Dynamics Nav"},"content":{"rendered":"<p>Today I want to describe a way to integrate Oracle into Navision. We use this way to migrate selected Tables and Views (rawdata) completely automatic into Dynamics Nav. This means we generate the Table-Structure (as a copy of the Oracle data dictionary) and import the data on the fly.<\/p>\n<p><a atomicselection=\"true\" href=\"http:\/\/www.forksoft.de\/blogImages\/OracleIntegrationintoNavision_CD3D\/odp2.jpg\"><img loading=\"lazy\" border=\"0\" width=\"320\" src=\"http:\/\/www.forksoft.de\/blogImages\/OracleIntegrationintoNavision_CD3D\/odp_thumb.jpg\" alt=\"Oracle Data Provider\" height=\"320\" style=\"border-width: 0px\" \/><\/a><\/p>\n<p>First of all one have to install the <a href=\"http:\/\/www.oracle.com\/technology\/tech\/windows\/odpnet\/index.html\">ODP.NET (Oracle Data Provider for .NET)<\/a>.<\/p>\n<p>Then create a new C# ClassLibrary-Project and add a reference to the installed OracleDataAccess-Assembly. (see <a href=\"http:\/\/www.forksoft.de\/download\/MigrationHelper.rar\">Sample-Project<\/a> as Reference)<\/p>\n<p>Install your COM-Object. (You can let Visual Studio do this for you)<\/p>\n<p>Then create a Navision-Object which connects to the ClassLibrary and interact with Oracle.<\/p>\n<p style=\"display: inline; float: none; margin: 0px; padding: 0px\" contentEditable=\"false\" id=\"57F11A72-B0E5-49c7-9094-E3A15BD5B5E6:bfdbcd70-17a6-4318-aaba-a5ad77ede7d2\" class=\"wlWriterSmartContent\">\n<pre style=\"background-color: white\"><!-- \r\n\r\nCode highlighting produced by Actipro CodeHighlighter (freeware) \r\nhttp:\/\/www.CodeHighlighter.com\/ \r\n\r\n--><span style=\"color: #0000ff\">IF<\/span><span style=\"color: #000000\"> g_MigrationHelper.OracleConnect( \r\n  g_ORAUserName,g_ORAPassword,g_ORADataSource) \r\n<\/span><span style=\"color: #0000ff\">THEN<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000ff\">BEGIN<\/span><span style=\"color: #000000\"> \r\n  <\/span><span style=\"color: #0000ff\">IF<\/span><span style=\"color: #000000\"> p_Test <\/span><span style=\"color: #0000ff\">THEN<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000ff\">BEGIN<\/span><span style=\"color: #000000\"> \r\n    MESSAGE(<\/span><span style=\"color: #ff0000\">'<\/span><span style=\"color: #ff0000\">Connection open<\/span><span style=\"color: #ff0000\">'<\/span><span style=\"color: #000000\">); \r\n    g_MigrationHelper.CloseOracleConnection; \r\n  <\/span><span style=\"color: #0000ff\">END<\/span><span style=\"color: #000000\"> \r\n<\/span><span style=\"color: #0000ff\">END<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000ff\">ELSE<\/span><span style=\"color: #000000\"> \r\n  ERROR(<\/span><span style=\"color: #ff0000\">'<\/span><span style=\"color: #ff0000\">Connection failed<\/span><span style=\"color: #ff0000\">'<\/span><span style=\"color: #000000\">);<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Today I want to describe a way to integrate Oracle into Navision. We use this way to migrate selected Tables and Views (rawdata) completely automatic into Dynamics Nav. This means we generate the Table-Structure (as a copy of the Oracle data dictionary) and import the data on the fly. First of all one have to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23,5,21],"tags":[148,649],"_links":{"self":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts\/80"}],"collection":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":0,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.navision-blog.de\/blog\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}