BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Can we connect to MemSQL database from IDT?
1 members found this topic helpful

 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 295



PostPosted: Fri Apr 15, 2016 2:10 pm 
Post subject: Can we connect to MemSQL database from IDT?

Hello,

I have a requirement to build the universe on top of MemSQL database. Just want to check if anyone aware of how to connect it through IDT/UDT and which drivers to need to have installed.

Please share any additional information to have as a BO dev

Appreciate it!
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11455
Location: Manchester, UK


flag
PostPosted: Mon Apr 18, 2016 10:03 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

It's wire-compatible with MySQL so give the MySQL drivers a try.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 295



PostPosted: Wed Apr 27, 2016 1:58 pm 
Post subject: Re: Can we connect to MemSQL database from IDT?

Thanks for the reply. Can you please let me know steps to connect to MySQL from IDT.

IDT-->Relational connection-->Oracle-->MySQL 5-->ODBC or JDBC?

Which drivers to select or need to have, ODBC or JDBC to connect to MySQL from IDT.

Appreciate the help.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11455
Location: Manchester, UK


flag
PostPosted: Tue May 10, 2016 4:52 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

I'd personally try ODBC first - I've never connected from IDT to MySQL though.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 295



PostPosted: Wed May 11, 2016 10:08 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

Yes, I can able to connect through ODBC drivers to MySQL db from IDT.

Thank You for suggestions.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11455
Location: Manchester, UK


flag
PostPosted: Wed May 11, 2016 10:14 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

Splendid. Thanks for updating the thread so that people know it succeeded. thumbsup.gif
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
TurningPointHolland
Principal Member
Principal Member



Joined: 06 Sep 2006

Posts: 357
Location: Gorinchem, Holland


flag
PostPosted: Fri May 10, 2019 3:47 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

hmmm,

Struggling now with exact the same problem.

I have a working 64 bits-ODBC connection which leads me to a MySQL Database.
PowerBI can connect without any problem with this database.

Now I try making a connection in IDT choosing Generic ODBC datasource and here within I choose ODBC Drivers...Then Next and fill in username, password and name of the source...

Then I get an error: "The name of the source is not found and there is no standard driver program found....
This is very frustating!

Should it be 32-bits? banghead.gif

_________________
Ton Vermeij
Senior SAP BI, Lumira, PowerBI, Tableau and Alteryx Consultant
Gorinchem, Holland, Europe
Owner of www.theturningpoint.nl and co-founder of
www.bi-united.nl (dutch BI-freelancers network)
Back to top
TurningPointHolland
Principal Member
Principal Member



Joined: 06 Sep 2006

Posts: 357
Location: Gorinchem, Holland


flag
PostPosted: Fri May 10, 2019 5:17 am 
Post subject: Re: Can we connect to MemSQL database from IDT?

Forget my remarks....I found it! Created a 32 bits connection after downloading the right 32 bits ODBC connector for MYSQL.

Now it works!



icon_surprised.gif seeya.gif

_________________
Ton Vermeij
Senior SAP BI, Lumira, PowerBI, Tableau and Alteryx Consultant
Gorinchem, Holland, Europe
Owner of www.theturningpoint.nl and co-founder of
www.bi-united.nl (dutch BI-freelancers network)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0363 seconds using 17 queries. (SQL 0.0099 Parse 0.0009 Other 0.0256)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo