load of two SQL databases - Qlik Community

antonrus · ‎2014-03-14

Hello, I apologize for maybe stupid question, but how to configure the load of two SQL databases? What synaxis need to use whatever after loading data from one database to start the download of the other? Thanks in advance!

its_anandrjs · ‎2014-03-14

Hi,

You can use its database connection string of different database and then followed by table load statement.

Thanks & Regards

Report Inappropriate Content · ‎2014-03-14

Hi,

Normally, for each database you need to put the ODBC connector in script before the query. Then, loading can be done.

If you want to join the outputs from each database in the same table, you just need a field with a common name.

jonathandienst · ‎2014-03-14

Hi

Open connection for first database.
Perform load from first database
Open connection for second database (closes the first connection automatically)
Perform load from second database

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

antonrus · ‎2014-03-14

How to open a connection to the second database? I write a line with many connection options - but it does not work.

Report Inappropriate Content · ‎2014-03-14

Just make another connection string, and then add another table. Maybe you can see attached file

its_anandrjs · ‎2014-03-14

Hi,

It is simple you have do do like this

Database Connection String 1

Table load statements Database 1

Database Connection String 2

Table load statements Database 2

Thanks & Regards

PrashantSangle · ‎2014-03-14

Hi,

In your Edit script window ,

at the bottom of your window you will see 'Data' tab

In that select Database->ODBC(Or OLEDB)->select Table Files by Click on Table File Button

Similar procedure you have to follow for your next database.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-03-14

Hi Ahtoh,

If the database is SQL then we can directly connect through the OLE DB Connection that is available in the Edit Script dialog. Select the OLE DB -> Microsoft OLE DB For SQL Provider/SQL Native Client -> Provide the server, authentication details, database name.

You will find the connection string pasted in the script dialog.

Repeat the same step for the second DB as well which will give you the second connection string.

Please save your credentials (ID and password) in the connection string else it will prompt to enter the details of the server every time when you reload the dashboard.

Hope this helps!

Thanks,

Sai

antonrus · ‎2014-03-16

Thank you all for your answers! I thank you for your help!