Connect NAV to External Oracle Database

(0) Share

Report

Posted on by Community Member

Good Afternoon ,

I would like to retreive data from an external Oracle database into Nav database.
What is the best way to do this, and what is the best way to validate data?

I am not sure are web services the best way to solve problem like this.

Thank you for your time.

Best Regards,
Snjezana

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (1)

Report

RE: Connect NAV to External Oracle Database

Thank you very much Mr. Roberto!

This might help me a lot.

Thank to all of you for helping me to find correct solution.

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (1)

Report

RE: Connect NAV to External Oracle Database

hi,

some suggestions

to load data you can:

use .net integration to call external web services exposed by Oracle, other systems etc. to load data, you can also run .net integration to call scheduled external scripts (SQL, Integration,Powershell, Windows etc....) to manage integration

you can use NAV 2017 EDI to import data via XML format (look at Currency fix rate import)

to validate data you can:

After import you can run scheduled codeunit directly on NAS to validate loaded data on Buffer Tables

you can Publish NAV pages\codeunites as web services to call Data Validation triggers exposed by web services.

My opinion: use webservices if possible.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (1)

Report

RE: Connect NAV to External Oracle Database

Dear Snjezana Miletic ,

Its great to inform you that we already have done it , we have running Banking system through Oracle , Customers , vendors all are created with that system so its useless to create those again in NAV system so we make integration as below

Process : we gather the required data from Oracle database and push NAV Integration database through JavaScript , .Net Script is running every 10 Minutes (scheduled via windows task scheduler) gather data from Integration database to Your NAV Live database

Integration Diagram as Below.. (Please Note that this is totally done by us)

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

RE: Connect NAV to External Oracle Database

There are different ways to do like

You can write web serivce

You can create xml or csv or txt file on required format and upload in navision using xmlport

Was this reply helpful? Yes No
ManishS 86 on at

Like (1)

Report

RE: Connect NAV to External Oracle Database

If standard pages of NAV can suffice your requirement then you can use them to insert data into NAV, else you will have to write your own code in NAV and publish that into web service for use.

Was this reply helpful? Yes No