Database connectivity

More
2 years 4 months ago #20991 by Wexexpress
Hello,

I am new and I also sent support an email. But I read this is where you respond faster so I will post my issue here.

We have installed 64 bit version of the Advanced ETL Processor Enterprise. We have installed Postgres database as well as MS Access. Both are not able connect using your tool yet we can connect using Qlikview directly. Right now we are also installing MySQL to see if there is any luck.

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago - 2 years 4 months ago #20992 by admin
Replied by admin on topic Database connectivity
Hello

Based on the information provided how do you expected us to help you?

Do not you think it is reasonable to provide us with a screenshot/error message/explanation of what you are trying to achieve?

Please read the forum rules and follow them

Mike
ETL Architect
Last edit: 2 years 4 months ago by admin.

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #20993 by Wexexpress
Replied by Wexexpress on topic Database connectivity
Sorry about that Mike. Oversight.
I have provided 3 screenshots.
Two from your tool not able to connect to Postgres db or Access
The other is connecting to the same Postgres db using Qlikview successfully
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #20994 by admin
Replied by admin on topic Database connectivity
For issues with ms access.

When you install our software there is an option to install ms access engine.
How you done that?

Also do you have ms office installed? If so is it 32bit or 64Bit?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #20995 by Peter.Jonson
Replied by Peter.Jonson on topic Database connectivity
We do have number of wiki articles dedicated to working with repository.
We usually recommend sql server express as the easiest to configure
Hope that helps

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 4 months ago #20996 by Wexexpress
Replied by Wexexpress on topic Database connectivity
Access DB is not the db we will use. We only tried once postgres did not work. We will try with Sql Server Express.
However, this does not explain why your tool cannot to our postgres db when other tools can. I don't want to be sifting through your wiki articles when I know it's not an db issue. Let's see what happens.

Please Log in or Create an account to join the conversation.