How to add data source in SpagoBI

We have already covered in our previous article about SpagoBI installation in Linux and working properly. After successfully installation of SpagoBI, Here i’m going to explain the steps to connect the new mysql datasource into SpagoBI Server.

Step-1

1) Login to biadmin >> Resources >> Data Source.
how-to-add-data-source-in-spagobi-1

Step-2

2) In Data Source area >> Add.
how-to-add-data-source-in-spagobi-2

Step-3

3) In Data Source area >> You need to enter your data source (mysql database details) values. Here i’m going to add mysql data source

Data source connection string:

  • Label : Your wish (add based on your DB or project name)
  • Description : Your wish (add based on your DB or project name)
  • Dialect : mysql (Must be choose mysql because we are going to connect mysql data source)
  • Choose : Read and Write
  • Choose : jdbc
  • Url : jdbc:mysql://Your-server-IP:3306/Your-DB-Name (I’m connecting to remote server that’s y i mentioned remote server IP, If you going to connect locally, add localhost)
  • User : Your-DB-User-Name
  • Password : Your-DB-Password
  • Driver : com.mysql.jdbc.Driver

how-to-add-data-source-in-spagobi-3

Step-4

4) After updating all the required above values. Test your data source value by clicking T button top most right on your SpagoBI.
how-to-add-data-source-in-spagobi-4
Yes, Data source is tested correctly.

Step-5

5) Finally save your data Source by clicking T button top most right on your SpagoBI.
how-to-add-data-source-in-spagobi-5

Step-6

6) See the below screen shot, your new data source has been created in SpagoBI.
how-to-add-data-source-in-spagobi-6
We are preparing all articles in-depth to understand by all level/stage Linux administrators. If the article is useful for you, then please spend less than a minute to share your valuable comments in our commenting section.

Please stay tune with us…Good Luck.

About Magesh Maruthamuthu

Love to play with all Linux distribution

View all posts by Magesh Maruthamuthu

23 Comments on “How to add data source in SpagoBI”

  1. thanks for this important information , i import my old database to new spagobi 5.2 , i have 2 question
    1- how to connect mysql to new spago 5.2 server,
    2- and i add data source in SpagoBI, Data source is tested correctly, but when i try to save my data source ‘cannot send response to the client’

    Please can you help me.

  2. Hello Magesh I have a doubt… I need to extract from a PostgresSQL as a data source two different kind of data and put it on SpagoBI 5 to make an analysis, the analysis is the following, I have to take from PostgreSQL the list called “Quotation” with a series of columns with their names and put it on Spago BI and I have to take also the data called “Invoice” with a series of columns too, and from these two data I have to take a common column between those two data source (Rel Nr is the name in this case) in order to see the duration of the time clients who ask for a quotation in a given date finally did a purchase too in a final date. the data starts since 1998, but I only want to work with data from 2010 until current. Invoice is the data of the clients who did a purchase and Quotation is the data of clients who ask for a Quotation. I really appreciate all the help you can provide me… I am testing this BI Tool and I need some lights with this. Thanks!

  3. Hello Magesh I have a doubt… I need to extract from a PostgresSQL as a data source two different kind of data and put it on SpagoBI 5 to make an analysis, the analysis is the following, I have to take from PostgreSQL the list called “Quotation” with a series of columns with their names and put it on Spago BI and I have to take also the data called “Invoice” with a series of columns too, and from these two data I have to take a common column between those two data source (Rel Nr is the name in this case) in order to see the duration of the time clients who ask for a quotation in a given date finally did a purchase too in a final date. the data starts since 1998, but I only want to work with data from 2010 until current. Invoice is the data of the clients who did a purchase and Quotation is the data of clients who ask for a Quotation. I really appreciate all the help you can provide me… I am testing this BI Tool.

  4. I am connecting SpagoBi to MYSQL. It’s correctly tested. But after that when i am saving it. It is throwing an error like “Cannot send Responce to client”. Anyone help me will appreciate that.

  5. Hi,

    I have added the below configurations for mssql and I get service error.

    Type: jdbc
    Dialect: SQL Server
    URL: sqlserver://localhost:1433;DatabaseName=***;SelectMethod=cursor
    UserID; ****
    PAssword: *****
    Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

    Please help me.

    Regards,
    Praveen

  6. vraiment merciiiiiiiiiiiiii , trés utile merci bien , svp s’il ya d’autre tuto me donner liens urgent

  7. I followed your directions exactly to connect to remote server , got service error ”
    “No suitable driver found for jdbc:mysql://192.168.100.34:3306/bitnami_sugarcrm”
    any thoughts?
    I tested connecting via ODBC from a server and it works.

Leave a Reply