Can I connect to Redshift with scriptcase? With SC postgresql connection or ODBC or anything else?
Look at the Redshift documentation for ODBC connect: Click!
And, what’s critical with your question?
[QUOTE=RHS;30145]Look at the Redshift documentation for ODBC connect: Click!
And, what’s critical with your question?[/QUOTE]
Hello,
We have a big data and we need to use our data with scriptcase. But we can’t handle our data with mysql, so we’re thinking about use to Amazon Redshift solution for that but I’m not sure about the scriptcase side. So can we connect to Redshift with SC ODBC Connection?
Thanks for your interest
Try it out with the posted link above …
Btw I’m using linux server, is it okay with odbc? should I install anything for that?
Hello,
I have a same problem . I wanna connect to Redshift Clusters . When ı try to connect via ODBC ı have a error ‘The extension is not loaded on the php.ini file.’ . My SC installed a server (linux).
my php.ini exist in /etc/php5/fpm/php.ini and ıt include codes about ODBC , in addition in /etc/php5/fpm/conf.d/odbc.ini has extension=odbc.so . So why can’t ı connect ODBC still ? Or anything else ?
hakan
Have you tested it with plain php and got it working?
Hi,
What do u mean with 'plain php '? I am trying with that directions : http://www.easysoft.com/developer/interfaces/odbc/linux.html
SC is using /opt/Netmake … as php.ini and actually there is odbc.so, there. In tutorial paths are little different from SC . I really confused . And in my diagnosis file ODBC is not available to use. What should I do now ? Also I have to say I installed SC on linux server except from my PC . So we have 2 different paths like SC -> /opt/Netmake … and /etc/php5 … .