Re: How connect to Datasul ERP? - Qlik Community

Report Inappropriate Content · ‎2013-09-24

Hi,

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

Report Inappropriate Content · ‎2014-03-12

Hugo!

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

did you buy a license to use ODBC or something?

vikasmahajan · ‎2014-03-13

Can you please tell what is your data source ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-03-13

Yes,

System: Datasul EMS 2.02

Database: Progress 10.2B

files extension is .db

spividori · ‎2014-03-13

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.

Report Inappropriate Content · ‎2014-03-13

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

there's no much information about it.

Report Inappropriate Content · ‎2014-03-13

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.

Report Inappropriate Content · ‎2014-03-13

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!

Report Inappropriate Content · ‎2014-03-13

following example

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

Report Inappropriate Content · ‎2014-03-13

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