Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Send data to Cloud

  1. How-to
0
Votes
Undo
  1. SHAMEEM KAKKAD
    SHAMEEM KAKKAD
  2. PowerBuilder
  3. Thursday, 2 February 2023 08:47 AM UTC

Hi,

I have a request from my company to upload specified data to cloud database which data in the local server. Whic method is perfect in Powerbuilder.

Using powerbuilder 2022 22.0.0.1892

Database = Sqlanywhere 16

I don't have any idea in the SnapDevelop tool.

Please advice me...

 

SQL Server Examples Database
Missing scrollbars in PB22 with themes
Accepted Answer
SHAMEEM KAKKAD
SHAMEEM KAKKAD Accepted Answer Pending Moderation
  1. Thursday, 9 February 2023 06:27 AM UTC
  2. PowerBuilder
  3. # Permalink

I managed this case like ...

created a proceedure and web service in my cloud database  (sqlanywhere) and called it from PB by httpclient method. Now it is working...

Thanks to all for your kind response...

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 9 February 2023 11:18 AM UTC
That's great Shameem!
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 9 February 2023 18:03 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Responses (4)
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Monday, 6 February 2023 06:55 AM UTC
  2. PowerBuilder
  3. # 1

Shameem

Possible Options
1.   If you could connect the database directly, then it would be lot easier.  You can connect as if it's a local database and do all your stuffs.   [ Direct connection to Cloud database is not advisable though]
2.  Replication:   One can replicate the data from one branch to another.  Lot of third-party tools are also available apart from the database provider itself. 
3.  Web API:  One can write API's to access / manipulate data at the Cloud end.   NO need to use Snapdevelop.  We have written code in PHP [ server end ] and accessed data using HTTPClient in Powerbuilder. Data transferred as JSON.

HTH

Happiness Always
BKR Sivaprakash

 

Comment
SHAMEEM KAKKAD
  1. SHAMEEM KAKKAD
  2. Thursday, 9 February 2023 06:24 AM UTC
Thanks
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 2 February 2023 12:31 PM UTC
  2. PowerBuilder
  3. # 2

Hi Shameem;

   Cloud DB's are just an IP address. Your PB App should be able to be allowed to directly connect. If that can be arranged, then you could use PB's Pipeline object to transfer the datum.

   The other scenario would be to FTP the SA database over to your cloud provider. Then run a PB App on the cloud platform using the PL approach on that environment.

Food for thought.  HTH 

Regards ... Chris 

Comment
SHAMEEM KAKKAD
  1. SHAMEEM KAKKAD
  2. Friday, 3 February 2023 08:12 AM UTC
if use pipline method, each time it will update through powerbuilder script ?.

Also if will update bulk data from various clients, any chance to slow ?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 3 February 2023 21:08 PM UTC
Yes, you are correct - PowerScript - thus it's fully programmable!

So the data set(s) that you move for what customer DB instance will be up to you. ;-)

Note that you can also use A) the old fashioned export / import approach using standard DB DML or B) some DBMS come with DBA utilities to be able to copy / move bulk data. Check with your DBA team. ;-)

  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 2 February 2023 11:03 AM UTC
  2. PowerBuilder
  3. # 3

Hi Shameem,

You might want to be more specific:

- Which cloud database? Azure ...., AWS .... , etc.

- I assume your local database is SqlAnywhere, but which database do you have on the "cloud"?

regards.

Comment
Load more comments
SHAMEEM KAKKAD
  1. SHAMEEM KAKKAD
  2. Friday, 3 February 2023 04:24 AM UTC
Azur
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 3 February 2023 08:22 AM UTC
If you do a search on "Azure" on this Q&A, you'll find many links: https://community.appeon.com/index.php/qna/q-a/search/YXp1cmU=

I'm sorry I don't know much myself on Azure connections.

  1. Helpful
SHAMEEM KAKKAD
  1. SHAMEEM KAKKAD
  2. Friday, 3 February 2023 10:40 AM UTC
Ok....

Thanks.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.