Accessing SugarCRM using Java

[SherlonV]

Hi im new to the forums and not totally experienced using SugarCRM Community Edition
I've already searched for related threads about java but I haven't seen a direct thread about it.

What I use:
http://www.sugarcrm.com/crm/download/sugar-suite.html
FastStack Windows Installer for 6.0.0R with SQL Server

I'm trying to use the data from SugarCRMs database and apply it onto a Java program.
I have tried looking into my ODBC connections but when I try to add a new connection
I don't see anything from the SugarCRM side.

My question is Is there a way to get the data from SugarCRM and use the data in a Java application?

Thanks to those who would reply

[Angel]

You can use SOAP to retrieve the data. Check out the developers web site for more info: http://developer.sugarcrm.com

If you want to extract data directly from the database via ODBC, you should be able to do it by setting up an ODBC datasource for MS-SQL

[SherlonV]

Hi firstly thanks for the reply.

I tried doing what you said about the ODBC connection. Though my problem is that
im not too clearly sure if i have the appropriate data sources. When you said MS-SQL
I went looking for a Microsoft SQL. Thing is nothing close came to it. Im wondering if
you are referring to a data source built in to Windows by default like MS Access or
something I need to get.

Thanks in advance for any replies

[SherlonV]

Just to clarify what I meant with my last post


Those are all the data sources i have starting from microsoft

i was wondering if you meant the MS SQL from this site;
http://www.microsoft.com/sqlserver/2...Downloads.aspx

[Angel]

"SQL Server" would allow you to connect to your Sugar database.

[SherlonV]

alright thanks ill give it a try

[SherlonV]

Ok its my mistake that ive said i have been using fast stack with SQL Server but apparentylu
im using the one with MYSQL. I suppose that the steps ive been taking are wrong due to my stupidness.

Like SQL Server is there a way to connect via MY SQL? Or should I use the SQL Server pack?

[Angel]

Yes, there is a way, but you likely need to install the MySQL ODBC drivers first.

[SherlonV]

It looks like i can connect via the obdc now but im having a hard time figuring out how to connect
to a specific schema/database. This cause I have several databases;
i.e.

information_schema (17)
mysql (17)
sugarcrm (99)
test (0)

my usual way of connecting via java is so

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package connectsugar;

import java.sql.ResultSet;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;

/**
 *
 * @author Chase
 */
public class Main {

    private	static Connection  conn;
    private     String      SQLStatement;
    private	String      url;
    private	static Statement   stmt;
    private	ResultSet   rset;
    int cid=0;


    public void test(){
            try {
            ResultSet rs;
            String url = "jdbc:odbc:db";						       
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 			
            conn = DriverManager.getConnection(url, "root@localhost", "1234");
            stmt = (Statement) conn.createStatement();
            SQLStatement = "SELECT MAX(Branchno) as 'max' FROM branch";
            rs = stmt.executeQuery(SQLStatement);
            rs.next();					
            cid = rs.getInt("max");
            cid++;

            stmt.close();
            conn.close();

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        }

    public static void main(String[] args) {       

    }
}

I was wondering how to connect to specific db's using this format. If i can't can anyone suggest how to connect using java?

[SherlonV]

Finally got it done through trial and error :|
Anyways thanks for your help with my issue
Closing thread

Um this sounds illy but i cant find the button for which to close this thread lol