Announcement

Collapse
No announcement yet.

[CRITICAL] Scriptcase with Amazon Redshift

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [CRITICAL] Scriptcase with Amazon Redshift

    Can I connect to Redshift with scriptcase? With SC postgresql connection or ODBC or anything else?
    Last edited by sekr; 12-09-2014, 06:34 AM.

  • #2
    Look at the Redshift documentation for ODBC connect: Click!

    And, what's critical with your question?
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #3
      Originally posted by RHS View Post
      Look at the Redshift documentation for ODBC connect: Click!

      And, what's critical with your question?
      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

      Comment


      • #4
        Originally posted by sekr View Post
        So can we connect to Redshift with SC ODBC Connection?
        Try it out with the posted link above ...
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          Btw I'm using linux server, is it okay with odbc? should I install anything for that?

          Comment


          • #6
            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

            Comment


            • #7
              Have you tested it with plain php and got it working?
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Hi,
                What do u mean with 'plain php '? I am trying with that directions : http://www.easysoft.com/developer/in...dbc/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 .. .

                Comment

                Working...
                X