topic Re: How connect to Datasul ERP? in QlikView

How connect to Datasul ERP?

Tue, 24 Sep 2013 11:21:05 GMT

Hi,

I'm from Brazil, and I'm with problem to connect my data base, we use Datasul ERP. Can anyone help me?

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 03:05:56 GMT

Hugo!

I have the same problem? how did you solve this?

did you buy a license to use ODBC or something?

Re: How connect to Datasul ERP?

vikasmahajan — Thu, 13 Mar 2014 05:17:19 GMT

Can you please tell what is your data source ?

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 12:26:50 GMT

Yes,

System: Datasul EMS 2.02

Database: Progress 10.2B

files extension is .db

Re: How connect to Datasul ERP?

spividori — Thu, 13 Mar 2014 12:44:02 GMT

HI.

I use databases with db extension. If they are the same database you should use the Microsoft Paradox Driver to create and configure the odbc. I install my program to install a driver called INTERSOLV ParadoxFile and that works very well with these databases.

Regards.

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:23:52 GMT

Sandro, is not a paradox Database. is Progress 10.2B.

there's no much information about it.

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:30:19 GMT

I use ODBC connection with User name and password to the database, which is usually sysprogress. And no need to buy to use the ODBC license.

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:35:10 GMT

Good to know that!

Thanks!

so,

user= sysprogress

password= sysprogress

can give an example of your connection string?

this odbc is generic and work with any versions? is already installed or i need to download ?

thanks again!

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:40:28 GMT

following example

If this is correct, please mark my answer as correct.

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:50:50 GMT

Hugo, Thanks for the printscreen.

But this odbc I need to install in my notebook that has qlikview? or how do i get the connection to the odbc from the server?

can you print an example from qlikview script connection?

thanks

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 13:56:54 GMT

First you need the databases are running with the sql service, after which the server will be extracted from the qvds you configure the ODBC connection.

You run your databases as a service or a .bat?

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 14:13:39 GMT

I think it run as a service.

this odbc need to be installed on my notebook?

Re: How connect to Datasul ERP?

Thu, 13 Mar 2014 14:20:45 GMT

If you are working using the notebook, but you need to install, I use ODBC64.

Re: How connect to Datasul ERP?

Fri, 11 Apr 2014 16:44:49 GMT

Hello Hugo, already got? I have this environment here.

- - - -

Ola Hugo, ja conseguiu ? Tenho esse ambiente aqui.

Note: Edited by Community Moderator to include English translation as a courtesy. Please use English language in main forums.

Re: How connect to Datasul ERP?

Mon, 10 Nov 2014 19:43:07 GMT

Cleber.nogueira can you share? I could not connect with my DATASUL .... Thanks

- - - -

Cleber.nogueira voce pode compartilhar? Não consegui conectar com meu DATASUL.... Obrigado

Note: Edited by Community Moderator to include English translation as a courtesy. Please use English language in main forums.

Re: How connect to Datasul ERP?

Wed, 03 Feb 2016 17:26:17 GMT

Hello Hugo, all right?

You succeeded in DataSul communication with Qlik?

I'm starting now and if you can help me with directions on how to proceed.

Thank you!

Amanda

- - - -

Olá Hugo, Tudo bem?

Você teve sucesso na comunicação do DataSul com o Qlik?

Estou começando agora e se você puder me ajudar com orientações de como proceder.

Obrigada!

Amanda

Note: Edited by Community Moderator to include English translation as a courtesy. Please use English language in main forums.