Connection info needed in SQLalchemy format for ibm_db_sa #235

Activity

1. idomic commented on Mar 20, 2023

   

   idomic

   on Mar 20, 2023

   More actions

   @swaroop-k are you sure the pip packages installed correctly?

   Try importing these, is it passing?

   import ibm_db
   import ibm_db_sa
   import ibm_db_dbi
   

   FYI @edublancas
2. edublancas commented on Mar 20, 2023

   

   edublancas

   on Mar 20, 2023

   More actions

   in those cases, it's usually easier to ensure you can establish a connection using create_engine and then pass the engine object:

   https://jupysql.ploomber.io/en/latest/howto.html#connect-to-existing-engine
3. vvujica1 commented on Apr 25, 2023

   

   vvujica1

   on Apr 25, 2023

   More actions

   Hi,

   To Connect Db2 to IBM Watson Studio, in the project you should add "new asset" select Db2 Cloud and complete credentials. Make sure that location is set same as Db2 (London, Dalas...). Once successfully connected, you can add your credentials and query to the notebook by clicking up right (icon looks like 0010).

   I think that other kind of connections wouldn't work.
4. edublancas commented on Apr 25, 2023

   

   edublancas

   on Apr 25, 2023

   More actions

   can you try connecting via create_engine? see the example here:

   import sqlalchemy
   from sqlalchemy import *
   import ibm_db_sa.ibm_db_sa
   db2 = sqlalchemy.create_engine('ibm_db_sa://user:password@host.name.com:50000/database')
   metadata = MetaData()
   users = Table('STAFF', metadata, 
   Column('ID', Integer, primary_key = True),
   Column('NAME', String(9), nullable = False),
   Column('DEPT', Integer, nullable = False),
   Column('JOB', String(5), nullable = False)
   )
   

   if that works, you can pass the engine object. e.g, if you do:

   db2 = sqlalchemy.create_engine('ibm_db_sa://user:password@host.name.com:50000/database')
   

   then:

   %sql db2
   

   %sql SELECT * FROM ...
   

   Note that this feature is only available on JupySQL, it won't work on ipython-sql:

   pip uninstall ipython-sql 
   pip install jupysql